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.
Hi,
I would like to request your help with the following inquiry, I need to create two measures that allow me to calculate the Average and Standard Deviation based on the following scenario:
This would be my raw data:
ID | Value |
A | 2 |
A | 3 |
B | 4 |
B | 5 |
C | 6 |
C | 7 |
The first step would be to calculate the summarized value of each ID:
ID | Sum |
A | 5 |
B | 9 |
C | 13 |
And then from that second table, I need to create the two measures to calculate:
1- Average = 9
2- Standard Deviation = 4
I would appreciate any help or guidance that you can provide me/
Here are your measures:
[Average] =
AVERAGEX(
DISTINCT ( T[ID] ),
CALCULATE( SUM[Value] )
)
[Standard Dev.] =
STDEVX.S(
DISTINCT ( T[ID] ),
CALCULATE( SUM[Value] )
)
Hello @Anonymous ,
You can simply group by in power query for the summarized value.
Use below measures for the calculation.
Average =
Hi @Anonymous,
Thank you very much for your help, to calculate the average I used this measure:
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 |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
42 | |
33 | |
30 | |
18 | |
18 |