Organizing Multiple Calculation Groups

Anonymous · ‎12-17-2023

Hey all - I was hoping someone could help me with a quick question regarding calculation groups in a model I've been working on. Any help or confirmation of my assumptions would be awesome.

I have a standard dataset with a sales fact table, a calendar table, and some dimensions which aren't relevant to my question. I've created a calculation group using for year-over-year comparisons in that when I select the field from the group in desktop it adds a 'current year', 'previous year', 'change', and 'chg %'. This works fine and is fantastic.

My question comes when I create a second calculation group functioning similarly but for month-over-month comparisons instead of yearly. It also works fine BUT in the actual report view the 2 groups show as 2 different tables. Functionally I have no issues, but I'd definitely prefer not to have a separate table for e v e r y group I create. I plan on having several and I anticipate them cluttering up the data pane in report view.

Am I missing a crucial aspect when using them? Is it possible to bucket all my calc groups and their respective calc items within a single table in the model similar to a measures table so that myself and the end users don't see 10 different tables with a singular field in them? Google hasn't helped me in the slightest so much so that I can't even find a single instance in which someone has more than 1 group in their model. It makes me believe I'm doing it incorrectly or just being picky about presentation.

TL;DR: I want a TableA with CalcGroup1, CalcGroup2, CalcGroup3, etc INSTEAD of TableA with CalcGroup1, TableB with CalcGroup2, TableC with CalcGroup3. Please tell me I'm stupid and this is easily acheivable or unecessary

parry2k · ‎12-17-2023

The calculation group is a table with special characteristics. Having said that you cannot have a table within a table. I hope it helps.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

parry2k · ‎12-17-2023

@Anonymous you can have multiple calculation items in one calculation group. Maybe I'm not following your question.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.