Creating calculation groups in Power BI Desktop using Tabular Editor

Thank you so much Marco. I have probably watched this video over 10 times. Other than just experimenting with these new features I finally figured out how to not show blank data as well as learning the power of the role of SELECTEDVALUE DAX as a "place holder" for any measure. This was awesome Marco. Thank you sir!

I tried but I have an issue

- Only calculated table options is available in tabular tools when I import the model
- Creating a calculated group disables all measures in the model. No more sigma next to the measures
- The icon in desktop for the calculated group looks just like the other tables

Thank you SQLBI and Marco. I have two questions.
1. If we are consuming the model from Excel (applied to the AAS model connecting from Excel to generate a pivot table), what is the implication?
2. What would be other use cases like we would like to have more than one calculation group in a single model?
Thanks again.

will this work if i publish it and only have PowerBi Pro - and not Premium ?

Hi Marco, This is not related to this topic but I have a Q. Are Collapsible Columns technically possible? Also, I don't know why but since I started using the group calculations, I have this folder that says " Format String Measure" which doubles all my DAXES and can't seem to get rid of it. Any idea?

Thank you! Is there a chance to sort a matrix by a calculation group item?

Thorough explanation in simplest way! Thank you, Marco!

Tabular Editor is such a savior. Thanks, Marco for the explanation.

Hi all - I'm still learning (lots) but I'm having trouble getting my calculation group for current and previous year to format in thousands to this £123k from this (£123,123.00). I'm sure this is simple to do, but after reading looking online, and see possible solution I'm still unable to resolve. Could I please ask for help?

Thank you very much for these clear explanations. I know now why and how to use calculation groups but I have a question: how to use only one measure in a graphic for example instead of all measures in the calculation group? I see the calculation groups like a way to write more measures in a few click (maybe I'm wrong) but if I have to write every single measure I think I'll lose all the benefits of this technic... Thank you again,

Just another short question, after adding a calculation group to my report, I'm missing the summarize (sum,avg,min,...) functionality in the fields tab (right click on an field). Is this because Tabular Editor changes the model here so that PBI can no longer offer this function?

Thanks for this useful video, I have a question when following steps. There is blank for my YOY% and YOY=Current value even I used same formulas as yours. Do u have any clues why would this happened?

How to go about if I only want to use let's say just YOY and YOY% for now, but I will also need PY. Or I need to make use of all the Time Intelligence measures that were created in the calculation group at once? I hope there's a way to select which specific TI measure is required for a specific visualization. Maybe there is, I just don't know how? Thanks!!

Great video, Marco any idea how I could do market share measure on tabular editor?

i was literally thinking about how to do this - so cool!

Hi Marco, I'd like to hear your thoughts on this - assuming that I need to iterate a simple calculation such as SUM( TableA[TotalSales] ) across multiple tables, is there a way to do this with Tabular Editor?

Here, it is safe to assume:
1. Column names across all tables are the same, i.e.: [TotalSales]
2. Due to the different nature of the data structure, it is impossible to merge all tables into one long table

I've checked out many articles and they've only been explaining how the measures can be manipulated for elements within the same column, in the same table. Now, as at the time of me repeating my questions a few times to discuss with my peers, I am more convinced to create a table (either in SQL/DAX/M) to append all the relevant fields that I need, and run a DAX measure. I know that it is possible to do the table appending in a SQL example by using UNION ALL, and I am almost certain DAX has the same capabilities too - just that I've never tried it before.

Your thoughts please?

Do I understand it correctly that when using calculation groups you can not display columns in any order? I.e. I can not display Sales, Margin, Sales PY, Margin PY, ... It has to be all Sales measures, then all Margin measures and so on ?

Can we select measures via filters so that you don't have to drag measures to the table? For example, instead of manually dropping the sales or cost measures to the table, can we list available measures to add that table?

What's the advantage of doing this versus a SWITCH function?

Hi, can you use Calculation groups in a line chart? For instance I'd like to show current YTD as one line and last year YTD as second line. When I drag in my calculated group it doesn't appear to create > 1 line.

Hi Sir, how can we do this on columns instead of measures? I have data in which there are multiple columns on which similar operations need to be performed. But they are fact tables from source data not calculated measures.

I am using this calculation group. this is very helpful. I am facing a problem when i export it from power bi service. the problem is - I see the measures like CY,PY,YoY,YoY% CY reach% to PY in columns in the visuals, but when i export this to an excel then these measures are not exported as columns but they are turned into rows and also changes the number formats from %s to numbers. Can you please let me know if you have a solution for this?

Marco, thank you a lot!
Could the calculation group be copied to another PBI file?

Thank you so much; If I could, I would put 100K like for this video. GRAZIE MILLE DAVVERO

Great video!!

can you let me know as to what is the syntax for calculate prior year same month value in calculation group in tabular editor. example, i want to know value of may 2021

thanks

Very useful tutorial. Thank you :-)

👋👋👋👋

I'm connecting my tabular editor to my Tabular cube, and appears disable, the option create > Calculation Group Alt+7 :-(

I had a calculation group for time intelligence and want to copy it to another report via create script but it give syntax error for the script. What is the solution?
create script is like;
{
"createOrReplace": {
"object": {
"database": "027c4.....

would've be nice if you could paste those formulas instead of just briefly showing them

This is great. Thanks, Marco!

The article from this video can be updated with the shiny DAX script for calculation groups

If we will apply % formatting then we will not able to apply conditional icon formatting is there any way ?

Is it possible to show different measures side-by-side in a matrix if I want to use calculation groups?
For example, I want to show on columns:

Revenue, Revenue YoY, Revenue YoY %, Profit, Profit YoY, Profit YoY%

I have created a Calculation Group with YoY and YoY %, but I need to show them for both - Profit and Revenue measures.

Is it possible? Or do I still need to create all these one-by-one?

There are no enough words in my vocabulary to describe how GREAT you are. Thank you very much for your great job. Hope one day I can visit your lectures and ask a looot of questions:-)thanks for your video and your books.

Thank you for the video, is super powerful. I had an issue related with percentage, the measure I dragging in is computed as a entire number, so my YOY% doesnt not come as a percentage. How can I solve it ? Thanks

After two years is it now possible to refer to another item in calculation group without running into troubles?

👏👏👏👏👏

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.

I have seen plenty of tutorials in different areas, but this is way far for what I have seen. Extensive and simple explanation to all of the necessary things about calculated groups. I remember that I was calling this DateTool into Multidimensional model using scopes.

So much in love with your lessons.

How can I add conditional formatting to my measures in calculated group?

Thanx for the video, Marco!

A question: is it possible to dynamically change the name of the calculation item? E.g. If we are displaying columns for the ”current week”, ”current week +1”, ”current week+2”, etc, can we instead of these static names display the actual week numbers?

Maybe a potential follow-up video topic? :)

Many thanx for all you do! ❤

This is so good! So easy to understand. Easily the best tutorial on the subject I've seen. Thank you so much for this and everything you do to advance Power BI. You guys are the best (granted, I'm not saying anything we don't all know)!

Thanks a lot! Great explanation, if I want to show a part of the group instead of the whole one, is there a way I could?

Thank you, Marco. great explanation and very useful. Can the calculation groups be used in row context where different metrics are presented in matrix table.