Forum Discussion
fetterr
3 years agoFrequent Visitor
Custom Matrix Subtotals
Hi All! I have matrix with 3 different row items, that all rollup into the cateogry "volume". This matrix has columns that groups the start of month for the last 12 months. This is a snapshot of ...
parry2k
Super User
3 years agofetterr the only way is to write your own measure for the subtotals, something like this, and use this measure in the matrix visual
My Measure =
IF (
HASONEVALUE ( Table[RollupCategory] ),
<<your Regular measure>>,
<<your subtotal calculation logic measure>>
)
👉 Learn Power BI and Fabric - subscribe to our YT channel - @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! ❤️