Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello,
my customer wants to have a matrix table on budget with that kind of columns :
Quarter 2, Quarter 3, Quarter 4, Total Quarter 2 => Quarter 4, for each line % of the total
I'd like to avoid to create a measure for each column, is there a way to avoid that ? (The number of quarter will depend of the version of the budget).
If I use a quarter field as a column of the table, I've most of it : I will simply and dynamically have a value for each quarter , then the total of the columns will be the total of all quarter. I just need additional column to add the % of each line of the total ; is there a way to get it ?
A idea may be to add one more total column by adding a field in column (exemple : year) with just one value for all the table : in that way I get another total ; then is there a way to change the calculation of the total to create the % of each line calculation ?
Best regards
@Bebs , Not very clear. But isinscope should help
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
or calculation group
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
User | Count |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
183 | |
92 | |
67 | |
62 | |
53 |