How to Custom Calculation of Matrix Row Totals

[Anonymous]

As shown in the figure！thanks😋

[Jihwan_Kim · Accepted solution]

Hi,

I assume the measure that is in the visualization is an average-measure.

Please check the below picture and the attached pbix file.

I tried to create a sample pbix file like below.

I hope the below can provide some ideas on how to create a solution for your datamodel.

Expected result measure: =
SWITCH (
    TRUE (),
    NOT ISFILTERED ( Category[Category] ) && ISFILTERED ( 'Product'[Product] ), AVERAGE ( Data[Value] ),
    ISFILTERED ( Category[Category] ) && ISFILTERED ( 'Product'[Product] ), AVERAGE ( Data[Value] ),
    SUM ( Data[Value] )
)