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...
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.