Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I am using a matrix chart , where I want to show the % of each category like below :
for MUID 500167, there are 3-categories and frequency of each is mentioned. here Category 'General Medicine' have F=2, so % is 2/4*100 ie 50%, later for 'Infection Diease' F =1 , so % =1/4*100 ie 25% ,so on.
can someone help me?
Solved! Go to Solution.
Hi @Anonymous ,
Create a measure as below:
Measure =
var _counttotal=CALCULATE(SUM('Table'[M_Frequency]),FILTER(ALL('Table'),'Table'[MUID]=MAX('Table'[MUID])))
Return
IF(ISINSCOPE('Table'[Category]),DIVIDE(MAX('Table'[M_Frequency]),_counttotal),BLANK())
And you will see:
For the related .pbix file,pls see attached.
Hi @Anonymous ,
Create a measure as below:
Measure =
var _counttotal=CALCULATE(SUM('Table'[M_Frequency]),FILTER(ALL('Table'),'Table'[MUID]=MAX('Table'[MUID])))
Return
IF(ISINSCOPE('Table'[Category]),DIVIDE(MAX('Table'[M_Frequency]),_counttotal),BLANK())
And you will see:
For the related .pbix file,pls see attached.
@Anonymous , This seem like % of the subtotal
You need to use all except
Assume you are using Cat under MUID (rows of matrix)
Try a new measure like
% of subtotal = divide([M_frequency], calculate([M_frequency] , allexcept(Table, Table[Cat])))
refer :https://community.powerbi.com/t5/Desktop/Percentage-of-subtotal/td-p/95390
@Anonymous
can you share a sample dataset or even better a PBIX file?
by the looks of it, you need an inital measure which would be:
frequency of selected categories =
CALCULATE( [Sum of Frequencies], ALLSELECTED (Table[Category]))
followed by the final measure::
% of selected categories = DIVIDE( [Sum of Frequencies], [frequency of selected categories])
Proud to be a Super User!
Paul on Linkedin.
@PaulDBrown - Tested your solution Paul, worked like a charm.
User | Count |
---|---|
87 | |
72 | |
68 | |
63 | |
54 |
User | Count |
---|---|
98 | |
89 | |
74 | |
67 | |
62 |