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.
Hi
Need help,
I want row wise 100% of category and sub category please suggest DAX code
I am using Matrix Visual for this, Category and Subcategory are Rows and A,B,C,D are single column , Please help
Solved! Go to Solution.
@Anonymous , You want % of row-wise total for a measure M1 . Sub Category on column
Divide([Measure], calculate([Measure],removfilters(Table[ Sub Category]) ) )
or
Divide([Measure], calculate([Measure],filter(allselected(Table), Table[Category] = max(Table[Category]) ) ) )
Percent of Total and Percent of SubTotal https://www.youtube.com/watch?v=6jTildcV2ho
@Anonymous , You want % of row-wise total for a measure M1 . Sub Category on column
Divide([Measure], calculate([Measure],removfilters(Table[ Sub Category]) ) )
or
Divide([Measure], calculate([Measure],filter(allselected(Table), Table[Category] = max(Table[Category]) ) ) )
Percent of Total and Percent of SubTotal https://www.youtube.com/watch?v=6jTildcV2ho
User | Count |
---|---|
21 | |
19 | |
12 | |
10 | |
9 |
User | Count |
---|---|
30 | |
25 | |
15 | |
13 | |
10 |