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 ?
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!
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.
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?
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, 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!
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
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 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
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 think you said calculation group 1000 times and calculation about 700. Very distracting and slow in delivering concept. Meant as constructive criticism
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 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.
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?
You have explained the concepts extremely well. Thanks for sharing!
Glad you like it 😊
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 ()
)
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!
Awesome Chandeep! Wonder if calculation groups will ever become a native feature. Thanks for demonstrating. Thumbs up!!
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 ✌🏻
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 ?
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!
Thank you Chandeep, this was very informative and crystal clear
Very lucid explanation with examples, Thanks a lot
Glad you liked it!
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.
Excellent video. Easy to follow explanation.
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 Chandeep, thank you so much for sharing all your knowledge!!
Glad you like it!
Can we do the same thing using DAX Studio? or some kind of work around within PBI Desktop?
just discovered your channel, love your videos :) very well explained!
Glad you like them!
Thank for explaining.
Glad it was helpful!
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?
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
Excellent presentation, thank you very much for your help
You are welcome!
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!
I tried to Implement the same but I'm not sure how to change the data type?
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.
can they be used in scorecards (or some other visual component), and how?
Hi Chandeep,
Thanks for your channel, amazing content.
Is recursion sideway calculation added recently to tabular editor or it was there from beginning.
Great tutorial. Keep the good work
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
Thanks for your sharing. So, where I can get the PBI file?
Interesting, Thank you very much
Hello My friend, Thank you... Great Video
Excellent!
Really helpful.
Thx, excellent!
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?
A great video again..
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.
HOW TO CREATE DIM DATE AND CREATE NEW TABLE
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
Hi..How can we add two group calculations
Ex: var lastmonth=........
var currmonth=.........
RETURN currmonth-lastmonth
The above is not working for me.....
Thanks
Perfect
Thanks 💚
supersticious as always
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
"Example isn't another way to teach, it is the only way to teach" *
Albert Einstein
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.
Thanks complex formulas explain simple way Can you help us source files for practice purpose
Finished watching
great video
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 😔
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.
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?
is calculation group can be worked in power BI?
Not yet
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
Extremely Helpful Chandeep. God bless .. Keep it up ...
Great video. Any chance to get a copy of the pbi file?
Thanks
Wonderful video Chandeep
Thank You !
Again, double excelent. Thx
Awesome explanation👍
Thanks Gwendoline
Wonderful video.. there is a lot to learn here
Really interesting...!!!!
Thank you, this was very helpful! :)
Glad it was helpful Evaldash!
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 💚
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!
Amazing thorough tutorial on Calculation Groups. Thanks
Glad you liked it!
Extremely useful tutorial. Super thanks!
Glad it was helpful!
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!