Forum Discussion
Calculating SUMX not correct
I am working an calculating the average for a set of rows based on a filter. The percentage 77.27 is incorrect since the average of the set would actually be 86.36. Expected Percentage = 19/22 = ....
Greg_Deckler
Community Champion
Community ChampionYIAX Try this:
Numerator_Measure = SUMX( FILTER( ALLSELECTED(TABLE), [STAGE] == "STAGE 1" ),[ROW_PERCENTAGE])