Total mistake

[Thulasiram]

Dear all

I have the following matrix.

I have the following DAX to calculate FFL_YTD_REV by adding the "Addback Dep" value.

The problem to solve for me here is the "Addback dep" is added in the total also in FFL_YTD_REV which I don't want.

How to achieve that, pls help.

Thanks.

[danextian · Accepted solution]

hI @Thulasiram ,

You need to add a condition so Addback Dep is not included in the total which would be something like:

IF (
    NOT ( HASONEVALUE ( 'table'[ffl major column] ) ),
    [mesure without addback dep],
    [measure with addback dep]
)

[Thulasiram]

Yes, it is working. Thanks @danextian .