Forum Discussion

aktripathi2506's avatar
aktripathi2506
Icon for Helper IV rankHelper IV
9 years ago

Calculating average for measure

I have 3 measures. Measure 1, Measure 2 and Measure 3. Measure 3 is getting calculated based on other two measure by using the formula:   Measure 3 = 1 – (Measure 1/ Measure 2)   Now I want to ...
Need Help
OwenAuger's avatar
OwenAuger
Icon for Super User rankSuper User
9 years ago

aktripathi2506

 

You can use AVERAGEX to calculate the arithmetic mean of an expression across the values of Group.

 

In your case, you could redefine Measure 3 to be:

 

Measure 3 =
AVERAGEX (
    VALUES ( YourTable[Group] ),
    1 - DIVIDE ( [Measure 1], [Measure 2] )
)

Or leave Measure 3 as is, and define an additional average measure:

 

Measure 3 avg =
AVERAGEX ( VALUES ( YourTable[Group] ), [Measure 3] )

Owen :)