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 all,
I need your help for an easy trick :
I have this table :
Table1
Hospital Step Progress
A Step1 50%
A S tep2 30%
A Step3 10%
B Step1 10%
B Step2 8%
B Step3 6%
C Step1 1%
C Step2 0%
C Step3 0%
I would like to obtain this table :
Table 2
Hospital Average
A 30%
B 8%
C 0.33%
How can i go from table 1 to table 2 ?
Thanks a lot !
Regards,
Séb
Solved! Go to Solution.
Hi @SebKaliVith,
You could try this formula below.
Table 2 = SUMMARIZE ( 'Table', 'Table'[Hospital], "average", CALCULATE ( AVERAGE ( 'Table'[Progress] ), FILTER ( 'Table', 'Table'[Hospital] = MAX ( 'Table'[Hospital] ) ) ) )
Here is the output you expected.
Best Regards,
Cherry
Hi @SebKaliVith,
You could try this formula below.
Table 2 = SUMMARIZE ( 'Table', 'Table'[Hospital], "average", CALCULATE ( AVERAGE ( 'Table'[Progress] ), FILTER ( 'Table', 'Table'[Hospital] = MAX ( 'Table'[Hospital] ) ) ) )
Here is the output you expected.
Best Regards,
Cherry
Just make a measure that calculates the average of the progress column, then drop that and hospital into a table
Hello,
Thank you for your answer !
But i obtain this table :
TABLE 2
Hospital AVerage
A 19%
B 19%
C 19%
I obtain the average of all my hospital progress, but i would like the average for each hospital.
Any idea ?
Best,
Séb
How have you worded your 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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |