Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
56 | |
27 | |
24 | |
14 | |
9 |
User | Count |
---|---|
77 | |
61 | |
47 | |
17 | |
12 |