Forum Discussion

rendalignacio's avatar
rendalignacio
Icon for Helper I rankHelper I
8 years ago
Solved

Incorrect matrix row total

Hi,   Can you please help me with this scenario?   The matrix row gives an incorrect average. Please see image:  
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    rendalignacio,

     

    You may use the following measure.

    Measure =
IF (
    HASONEFILTER ( Table1[Test] ),
    AVERAGE ( Table1[Value] ),
    AVERAGEX (
        ALLSELECTED ( Table1[Test] ),
        CALCULATE ( AVERAGE ( Table1[Value] ) )
    )
)
v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
8 years ago

rendalignacio,

 

You may use the following measure.

Measure =
IF (
    HASONEFILTER ( Table1[Test] ),
    AVERAGE ( Table1[Value] ),
    AVERAGEX (
        ALLSELECTED ( Table1[Test] ),
        CALCULATE ( AVERAGE ( Table1[Value] ) )
    )
)