topic Re: Is there a way to subtotal/total column values using alternating columns in DAX Commands and Tips

Is there a way to subtotal/total column values using alternating columns

AaronToth — Fri, 09 Sep 2022 16:14:29 GMT

We have a matrix that has 2 columns (Amount and Quanity) and the matrix is broken up by Year. So the matrix would look like this

Amount/Quantity - Amount/Quantity - Amount/Quantity (with headers above 2005, 2006 and 2007)

Question: Is it possible to subtotal/total to the right for just one column (i.e. Amount). Right now if you turn the sub-total/total on, it will add all values across the grid. Can we separate these?

This is what we would like to have

Thanks,
Aaron

Re: Is there a way to subtotal/total column values using alternating columns

Greg_Deckler — Fri, 09 Sep 2022 16:16:23 GMT

AaronToth There is a way but it is not exactly pretty. You can shrink the unwanted columns or you can do this:

https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/963588#M428

Re: Is there a way to subtotal/total column values using alternating columns

AaronToth — Mon, 12 Sep 2022 11:24:41 GMT

Thanks Greg_Deckler

Aaron Toth