Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
hello,
i have a matrix with several groups, and i have a measure that calculates for each row the average of the last 6 months.
now i am looking for a way to get for each row the percentage of it out of its group.
for example the first row's percentage should be 23.9% >> 151049/SUM(all other values)
thank you very much for your help.
Solved! Go to Solution.
Hi @Anonymous ,
I created some data:
Here are the steps you can follow:
1. Create measure.
Measure =
IF(
ISINSCOPE('Table'[Group]) && NOT(ISINSCOPE('Table'[Group1])),
DIVIDE(
[NNS Avg 6 Months],
SUMX(
FILTER(ALLSELECTED('Table'),
'Table'[Sub-Category]=MAX('Table'[Sub-Category])),[Amount]))
,[NNS Avg 6 Months])
2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @Anonymous ,
I created some data:
Here are the steps you can follow:
1. Create measure.
Measure =
IF(
ISINSCOPE('Table'[Group]) && NOT(ISINSCOPE('Table'[Group1])),
DIVIDE(
[NNS Avg 6 Months],
SUMX(
FILTER(ALLSELECTED('Table'),
'Table'[Sub-Category]=MAX('Table'[Sub-Category])),[Amount]))
,[NNS Avg 6 Months])
2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
You can use
sub cat % =
VAR currentValue = [NNS Avg 6 Months]
VAR totalValue =
CALCULATE ( [NNS Avg 6 Months], ALLSELECTED ( 'Table'[Sub-category] ) )
RETURN
DIVIDE ( currentValue, totalValue )
User | Count |
---|---|
48 | |
44 | |
19 | |
14 | |
14 |
User | Count |
---|---|
107 | |
57 | |
29 | |
20 | |
16 |