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 have a column in a table with below expression
AVERAGEX(VALUES('VW_PRS_LifeCycleState2'[LifeCycleState]),CALCULATE(AVERAGE(VW_PRS_LifeCycleState2[Target_Round2])))
I need to have the total displayed with SUM of "Average" of all the detail rows. The above expression is working fine for Average in detail rows while total is not correct. Currently total as well is doing the average while i need the SUM of averages.
Please suggest?
Thanks
Gaurav
Solved! Go to Solution.
Hi @GM17,
Please create a measure with below formula:
Average = SUMX ( VALUES ( 'VW_PRS_LifeCycleState2'[LifeCycleState] ), AVERAGE ( VW_PRS_LifeCycleState2[Target_Round2] ) )
Best regards,
Yuliana Gu
Hi @GM17,
Please create a measure with below formula:
Average = SUMX ( VALUES ( 'VW_PRS_LifeCycleState2'[LifeCycleState] ), AVERAGE ( VW_PRS_LifeCycleState2[Target_Round2] ) )
Best regards,
Yuliana Gu
Hi
strange, but for some reason it works here is such a formula
Measure = AVERAGEX(VALUES('table'[name]);SUM('table'[values]))
Hi Yuliana Gu,
i am also looking for the similar type of solution , i have tried but no luck .can you please have a look on it.
https://community.powerbi.com/t5/Desktop/Sum-of-Average/m-p/288894#M127118
thanks,
@GM17 go to the data
Create the New Column & Enter the Function
SumofAverage =AVERAGEX(VALUES('VW_PRS_LifeCycleState2'[LifeCycleState]),CALCULATE(AVERAGE(VW_PRS_LifeCycleState2[Target_Round2])))
Create New Column
Column = [SumofAverage ]
if you find any difficulty share the sample data
Regards,
Chetan K
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |