Forum Discussion

Thulasiram's avatar
Thulasiram
Helper 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 a...
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]
)
danextian's avatar
danextian
Super 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]
)