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.
I have the following data:
ID | Location | Metric | Value |
1 | A | Population | 1000 |
2 | A | Average Income | 50000 |
3 | B | Population | 2000 |
4 | B | Average Income | 30000 |
5 | C | Population | 5000 |
6 | C | Average Income | 20000 |
How do I get the following result:
sum(Value of Population * Value of Average Income) / sum(Value of Population)
So when I select locations A and B, it should calculate each location's Value of Population * Value of Average Income then sum them together.
Thanks.
Solved! Go to Solution.
Hi @Anonymous
Try this measure:
Sum PXAV =
VAR _A =
SUMMARIZE (
'Table',
'Table'[Location],
"PXAI",
CALCULATE ( SUM ( 'Table'[Value] ), 'Table'[Metric ] = "Population" )
* CALCULATE ( SUM ( 'Table'[Value] ), 'Table'[Metric ] = "Average Income" )
)
RETURN
SUMX ( _A, [PXAI] )
Output:
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
Hi @Anonymous
Try this measure:
Sum PXAV =
VAR _A =
SUMMARIZE (
'Table',
'Table'[Location],
"PXAI",
CALCULATE ( SUM ( 'Table'[Value] ), 'Table'[Metric ] = "Population" )
* CALCULATE ( SUM ( 'Table'[Value] ), 'Table'[Metric ] = "Average Income" )
)
RETURN
SUMX ( _A, [PXAI] )
Output:
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
Thank you, this is exactly what I need.
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 |
---|---|
105 | |
96 | |
79 | |
67 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |