Forum Discussion
Custom Total Column in Power Bi Matrix
Hi. Is there a way to show only one column with a measure (average, sum, percentage, etc.) at the end of matrix in Power BI? I want to show one column with a measure like the difference between 2019...
Not entirely sure, but you may want something like: https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/963588#M428
Greg_Deckler thank you for your response.
I've created a new column for the revenue performance:
...and a hierarchy based on Year, Month and Revenue Performance:
When I try to create the measure, I can't reach this "YEAR Hierarchy" to put it in a VAR:
I'm doing these things right?
Thanks.
marcoarib I don't use an actual DAX hierarchy in my solution, it is an ad-hoc hierarchy but even so, the same technique should work, you would refer to the individual levels of the hierarchy, not the hierarchy itself.