Getting Started with Calculation Groups in Power BI 

Revisiting this great tutorial, Power BI now supporting Calc. Groups, but still Tabular Editor is the master.

You have explained the concepts extremely well. Thanks for sharing!

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 () )

As always Chandeep, explanations crystal clear! thanks for sharing !

Tabular Editor is to me one of the most beautiful tools if you are working with PBI.. very good explained! Congrats!

Amazing thorough tutorial on Calculation Groups. Thanks

Very lucid explanation with examples, Thanks a lot

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.

Thank you Chandeep, this was very informative and crystal clear

Thank for explaining.

Excellent video. Easy to follow explanation.

Was waiting for.this as I'm a beginner 😁

Amazing …. You explained it very well. Precedence concept was easy to understand. Thanks chandeep for this video ✌🏻

Great video Chandeep, thank you so much for sharing all your knowledge!!

Extremely useful tutorial. Super thanks!

Excellent presentation, thank you very much for your help

Again, double excelent. Thx

Awesome explanation👍

Thank you for doing this video. It is very helpful. Looking forward to seeing more of your work. :)

Extremely Helpful Chandeep. God bless .. Keep it up ...

just discovered your channel, love your videos :) very well explained!

Finished watching

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 ?

Awesome Chandeep! Wonder if calculation groups will ever become a native feature. Thanks for demonstrating. Thumbs up!!

Wonderful video.. there is a lot to learn here

Hello My friend, Thank you... Great Video

Great tutorial. Keep the good work

Interesting, Thank you very much

Thank you, this was very helpful! :)

Wonderful video Chandeep

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.

Thanks complex formulas explain simple way Can you help us source files for practice purpose

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!

Excellent video on calculation groups. Is there a way to highlight one of the 'columns' in BOLD, say a Total or a special result?

great video

Really helpful.

Excellent!

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!

Thx, excellent!

Really interesting...!!!!

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.

A great video again..

Can we do the same thing using DAX Studio? or some kind of work around within PBI Desktop?

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, Thanks for your channel, amazing content. Is recursion sideway calculation added recently to tabular editor or it was there from beginning.

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

can they be used in scorecards (or some other visual component), and how?

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?

Perfect

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 😔

Thanks Chandeep, excellent video on calculation groups and its beauty, do tabular editor 2 and 3 has any technical i.e. coding challenges?

Hi..How can we add two group calculations Ex: var lastmonth=........ var currmonth=......... RETURN currmonth-lastmonth The above is not working for me..... Thanks

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?

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

supersticious as always

Thanks for your sharing. So, where I can get the PBI file?

Great video. Any chance to get a copy of the pbi file? Thanks

I tried to Implement the same but I'm not sure how to change the data type?

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 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?

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

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?

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.

HOW TO CREATE DIM DATE AND CREATE NEW TABLE

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 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

is calculation group can be worked in power BI?

"Example isn't another way to teach, it is the only way to teach" * Albert Einstein

Aitäh!

I think you said calculation group 1000 times and calculation about 700. Very distracting and slow in delivering concept. Meant as constructive criticism