Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I'm trying to create a matrix in which the user can see a measure per month for a running year with a total column, combined with a column that shows the year to date total. Something like this:
I have created the measure for running year, which works as intended. And I can create a measure for the YTD calculation but when I add that to the matrix it get sliced automatically which I don't want. Hiding extra columns is not really an option since the user will export the matrix to excel and doesn't want to have any extra columns show up there.
Is there a way to tell the matrix it should slice one measure but not the other?
Any suggestions and / or other solutions are appreciated.
You can try this measure:
Total YTD = IF(ISINSCOPE(Table[YearMonth]), BLANK(), [Total YTD])
The columns will still be there (though you can reduce their width) but there will be no values displayed
Proud to be a Super User!
Paul on Linkedin.
It's a nice trick but won't the columns also show up in the export?
User | Count |
---|---|
104 | |
92 | |
88 | |
78 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |