Solved: Re: Incorrect matrix row total

rendalignacio · ‎10-20-2017

Hi,

Can you please help me with this scenario?

The matrix row gives an incorrect average. Please see image:

v-chuncz-msft · ‎10-22-2017

You may use the following measure.

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-chuncz-msft · ‎10-22-2017

@rendalignacio,

You may use the following measure.

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.