Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Showing Grand Total columns for select Calcs when using a Calculation Group in a Matrix....

 

I have some data which needs to be presented like this:

 

WATYF_1-1692225817296.png

 

For past (fully completed) quarters, I only need to see one Measure (Sales). Fur current/future quarters, I need to see a few Measures. I could easily build this in 30 seconds if I didn't mind seeing Plan/Prior/Delta for the PAST Quarters even though they were empty (and Sales for the cur/future Quaters even when they're empty), but that looks awful. (Speaking of, there should be a built-in way to hide any NULL columns in a Matrix, but I digress).

 

Many hours of scouring the internets later, I have worked out how to (mostly) do this via a Calculation Group. I create Sales/Plan/Prior/etc Calc Items, and then add the (DateDim) Quarter to the Matrix Columns, add the Name of the Calc Group to the Matrix Columns, then click the "expand all" drilldown button (a tip that none of the tutorials happened to mention), and I can see my Quarters (and the "Measures" in each one), and only the populated Calc Items show up for each Quarter.

 

The problem is, then I can't show TOTAL year Measures, because there is no such thing as the "Total" Quarter, (and by using a Calc Group, I basically "break" the Subtotal logic of the Matrix so it can't be displayed anymore).

 

So, is there a way to say, "Show me these Calc Items by Quarter AND THEN show me a grand total of these Calc Items after that"? I'm guessing I would have to somehow generate a "Total" Quarter and then run the same Calc Items through that, but I don't know how to do that.

 

I should note that I'm also open to completely different ways of achieving the above sample (assuming any exist).

0 REPLIES 0

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.