Thanks Chandeep! I've been racking my brain trying to figure out how to get more than one calculation item to show within a visual without adding an additional calculation group. The sideway incursion gave me an idea to create a "Switch" calculation item that refers to other items in the calculation group. It just works! Cheers. SWITCH ( TRUE (), ISSELECTEDMEASURE ( [Dynamic Statistical Measure] ),--Blank measure within calc group CALCULATE ( SELECTEDMEASURE (), '1_group_statistics'[Statistical Measure] = "Linear Regression - Dynamic Measure" --calculation item that refers to a calculation group with higher precedence ), ISSELECTEDMEASURE ( [Dynamic Statistical Secondary Measure] ), --Blank measure within calc group CALCULATE ( SELECTEDMEASURE (), '1_group_statistics'[Statistical Measure] = "Linear Regression - Dynamic Secondary Measure" --calculation item that refers to a different calculation group with higher precedence ), SELECTEDMEASURE () )
Hi. I like how straightforward your video is. I just have a question, how do we now apply conditional formatting to values in a calculation group. For example, I wanted to find the max value across all time periods ?
Hi, Thanks for helping us to improve our knowledge in Power BI. Please help me if you know any solution to convert a calculated measure to calculated column. Thanks!
Why format of columns disappear. For example, column "Units" has a number format before calculation groups. After the calculation group, the format is not working anymore. It means you can't use column Units for another visual object. Please let me know about this...thank you so much!
Hi Sir, Thanks for sharing amazing feathers. I am trying to follow all your steps but for last year and YoY% I am getting the same values as this year. not sure what I a doing wrong. Would you be able to let me know how you have managed the relationships here. May be that's where I am making mistakes.
Your total YTD for year 2012 at 23:08 should have been 30,783 instead of 30,784. Why that extra 1? Can't figure out, but a very nice and detailed explanation of calculation groups.
Hi Chandeep, Thanks for your channel, amazing content. Is recursion sideway calculation added recently to tabular editor or it was there from beginning.
Hey I want to know how we can do the calculation where I went to calculate row wise i.e in one row I need sum of few items and below that row I need percentage of those items divided by the total of those items
Hi,very nice explanation on calculation group.can you explain how to work with format the measure with decimal and with out decimal based units,thousands,millions selection in slicer. I want to use the format value in column chart
When come to Group calculation, there is one major drawback is the selectedmeasure(). So I drag Revenue, profit, or any measure, but as a user, how to show that the based measure is revenue, profit, expenses or any measures so that user can understand the visual is measuring what?
Hi Chandeep, Awesome video! I have some issues with Tabulor editor, that i really hope you can help me with. Once i type in my table or Collum name in the expression, i don´t see any suggestions for my queries, and by typing the full expression, it can´t find any reference. Tables are visible in the model in Tabular editor 2.19.0
Hi Master 😉, Thanks for the interesting videos. One curiosity question, what is the best practice for the calendar table re time intel calculations, should it be till end of current year or till end of sales table?
I have 4 pricing type 12 sales total - Contract , Standard, buyin, Override. We want to see sales impact by price increase 1%, 1.5%, 2% and so on. but want to exclude buyin and override from calculating but they should return 12 sales total without any increase. So my total should be Contract , standard with price increase and Buying, override without price increase. I used calculate columns to use "If" and "switch"function but the result is not dynamic when i change % increase.
Hi Chandeep. Nice video. I have one question here, if l have 10 measures in the table and I want to apply the calculation group only to 5 measures in the table and remaining 5 should be as it is. Is this achievable using the selected measure function?
Great explanation! Thank you! Question, are there performance differences between using measures versus sideways references within items. Using calculation items as your base measure greatly simplifies your model, but I'm finding much slower in performance. Is this true in general, or possibly something I'm doing wrong with calculation groups. . Thank you!
Hi..How can we add two group calculations Ex: var lastmonth=........ var currmonth=......... RETURN currmonth-lastmonth The above is not working for me..... Thanks
I dont get the intelligence opcion when typing the name of my calculated group. Does anyone know why? Without it I cannot reference the calculation item.
Hi Chandeep Thanks for the wonderful video as always I have a question not related to Tabular, its related to dax I want to calculate average of 1st quarter of last 5 years ( avg of 1st qtr of 2021, 1st qtr of 2020, 1st qtr of 2019, 1st qtr of 2018, 1st qtr of 2017 and similarly for month and day ). Can you help me crack the logic. Thanks in advance
I think you said calculation group 1000 times and calculation about 700. Very distracting and slow in delivering concept. Meant as constructive criticism
Revisiting this great tutorial, Power BI now supporting Calc. Groups, but still Tabular Editor is the master.
Thanks Chandeep! I've been racking my brain trying to figure out how to get more than one calculation item to show within a visual without adding an additional calculation group. The sideway incursion gave me an idea to create a "Switch" calculation item that refers to other items in the calculation group. It just works! Cheers.
SWITCH (
TRUE (),
ISSELECTEDMEASURE ( [Dynamic Statistical Measure] ),--Blank measure within calc group
CALCULATE (
SELECTEDMEASURE (),
'1_group_statistics'[Statistical Measure] = "Linear Regression - Dynamic Measure" --calculation item that refers to a calculation group with higher precedence
),
ISSELECTEDMEASURE ( [Dynamic Statistical Secondary Measure] ), --Blank measure within calc group
CALCULATE (
SELECTEDMEASURE (),
'1_group_statistics'[Statistical Measure] = "Linear Regression - Dynamic Secondary Measure" --calculation item that refers to a different calculation group with higher precedence
),
SELECTEDMEASURE ()
)
You have explained the concepts extremely well. Thanks for sharing!
Glad you like it 😊
Tabular Editor is to me one of the most beautiful tools if you are working with PBI.. very good explained! Congrats!
As always Chandeep, explanations crystal clear! thanks for sharing !
Glad you liked it!
Hi. I like how straightforward your video is.
I just have a question, how do we now apply conditional formatting to values in a calculation group.
For example, I wanted to find the max value across all time periods ?
Can we do the same thing using DAX Studio? or some kind of work around within PBI Desktop?
Hi, Thanks for helping us to improve our knowledge in Power BI. Please help me if you know any solution to convert a calculated measure to calculated column.
Thanks!
Why format of columns disappear. For example, column "Units" has a number format before calculation groups. After the calculation group, the format is not working anymore. It means you can't use column Units for another visual object. Please let me know about this...thank you so much!
Hi Sir, Thanks for sharing amazing feathers. I am trying to follow all your steps but for last year and YoY% I am getting the same values as this year. not sure what I a doing wrong. Would you be able to let me know how you have managed the relationships here. May be that's where I am making mistakes.
Amazing thorough tutorial on Calculation Groups. Thanks
Glad you liked it!
Thank you Chandeep, this was very informative and crystal clear
Excellent video. Easy to follow explanation.
Amazing …. You explained it very well. Precedence concept was easy to understand. Thanks chandeep for this video ✌🏻
This is a great video. It was a bit fast in a few areas but I quickly understood it once I watched the section a second time.
Glad it helped!
Excellent video on calculation groups. Is there a way to highlight one of the 'columns' in BOLD, say a Total or a special result?
Extremely Helpful Chandeep. God bless .. Keep it up ...
Your total YTD for year 2012 at 23:08 should have been 30,783 instead of 30,784. Why that extra 1? Can't figure out, but a very nice and detailed explanation of calculation groups.
Very lucid explanation with examples, Thanks a lot
Glad you liked it!
Thanks complex formulas explain simple way Can you help us source files for practice purpose
Was waiting for.this as I'm a beginner 😁
Again, double excelent. Thx
Awesome Chandeep! Wonder if calculation groups will ever become a native feature. Thanks for demonstrating. Thumbs up!!
Any relationship needs to be created for the calculation group?
Hi Chandeep,
Thanks for your channel, amazing content.
Is recursion sideway calculation added recently to tabular editor or it was there from beginning.
Hey I want to know how we can do the calculation where I went to calculate row wise i.e in one row I need sum of few items and below that row I need percentage of those items divided by the total of those items
Thanks for your sharing. So, where I can get the PBI file?
Great video Chandeep, thank you so much for sharing all your knowledge!!
Glad you like it!
can they be used in scorecards (or some other visual component), and how?
Extremely useful tutorial. Super thanks!
Glad it was helpful!
Thanks Chandeep, excellent video on calculation groups and its beauty, do tabular editor 2 and 3 has any technical i.e. coding challenges?
Hi,very nice explanation on calculation group.can you explain how to work with format the measure with decimal and with out decimal based units,thousands,millions selection in slicer. I want to use the format value in column chart
Excellent presentation, thank you very much for your help
You are welcome!
When come to Group calculation, there is one major drawback is the selectedmeasure(). So I drag Revenue, profit, or any measure, but as a user, how to show that the based measure is revenue, profit, expenses or any measures so that user can understand the visual is measuring what?
Great tutorial. Keep the good work
Hi Chandeep,
Awesome video!
I have some issues with Tabulor editor, that i really hope you can help me with.
Once i type in my table or Collum name in the expression, i don´t see any suggestions for my queries, and by typing the full expression, it can´t find any reference. Tables are visible in the model in Tabular editor 2.19.0
Hi Master 😉, Thanks for the interesting videos. One curiosity question, what is the best practice for the calendar table re time intel calculations, should it be till end of current year or till end of sales table?
I have 4 pricing type 12 sales total - Contract , Standard, buyin, Override. We want to see sales impact by price increase 1%, 1.5%, 2% and so on. but want to exclude buyin and override from calculating but they should return 12 sales total without any increase.
So my total should be Contract , standard with price increase and Buying, override without price increase. I used calculate columns to use "If" and "switch"function but the result is not dynamic when i change % increase.
Great video. Any chance to get a copy of the pbi file?
Thanks
Thank you for doing this video. It is very helpful. Looking forward to seeing more of your work. :)
Glad you like this! Sure, stay with goodly 💚
I tried to Implement the same but I'm not sure how to change the data type?
Wonderful video.. there is a lot to learn here
Finished watching
Awesome explanation👍
Thanks Gwendoline
just discovered your channel, love your videos :) very well explained!
Glad you like them!
Excellent!
Hello My friend, Thank you... Great Video
Hi Chandeep. Nice video. I have one question here, if l have 10 measures in the table and I want to apply the calculation group only to 5 measures in the table and remaining 5 should be as it is. Is this achievable using the selected measure function?
Thank for explaining.
Glad it was helpful!
Interesting, Thank you very much
Great explanation! Thank you! Question, are there performance differences between using measures versus sideways references within items. Using calculation items as your base measure greatly simplifies your model, but I'm finding much slower in performance. Is this true in general, or possibly something I'm doing wrong with calculation groups. . Thank you!
I can't say that with certainty. Try with and without calculation group.
Also check the performance of your base measure.
Good Video thank you! 👍I Hope the Tabular Editor 2.0 will be available over a Long time. The latest Version is Not for free 😔
Wonderful video Chandeep
Thank You !
Thank you, this was very helpful! :)
Glad it was helpful Evaldash!
Really helpful.
Really interesting...!!!!
Wow, that’s all I can say I watched a few tabular editor videos and this one explains it best, thanks a mil, and does version 2 still worth using?
TE2 is still pretty good but DAX editing experience isn't good.
@@GoodlyChandeep thanks for the reply, so it’s advisable to upgrade to 3
@@keagankemp6275 Yes. It's totally worth it!
A great video again..
Hi..How can we add two group calculations
Ex: var lastmonth=........
var currmonth=.........
RETURN currmonth-lastmonth
The above is not working for me.....
Thanks
I dont get the intelligence opcion when typing the name of my calculated group. Does anyone know why? Without it I cannot reference the calculation item.
Hi Chandeep
Thanks for the wonderful video as always
I have a question not related to Tabular, its related to dax
I want to calculate average of 1st quarter of last 5 years ( avg of 1st qtr of 2021, 1st qtr of 2020, 1st qtr of 2019, 1st qtr of 2018, 1st qtr of 2017 and similarly for month and day ). Can you help me crack the logic. Thanks in advance
Thx, excellent!
HOW TO CREATE DIM DATE AND CREATE NEW TABLE
great video
is calculation group can be worked in power BI?
Not yet
"Example isn't another way to teach, it is the only way to teach" *
Albert Einstein
supersticious as always
Thanks !
I have a query which is not solver by any body even Microsoft community। I think you can do that।।if yes i will share the details
Perfect
Thanks 💚
Aitäh!
Thanks for the tip! 😀
I think you said calculation group 1000 times and calculation about 700. Very distracting and slow in delivering concept. Meant as constructive criticism