Forum Discussion

Thulasiram's avatar
Thulasiram
Icon for Helper II rankHelper II
2 years ago
Solved

Total mistake

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.

Need Help
  • danextian's avatar
    danextian
    2 years ago

    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]
)

2 Replies

  • danextian's avatar
    danextian
    Icon for Super User rankSuper User
    2 years ago

    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]
)