Forum Discussion

spagad6263's avatar
spagad6263
Post Patron
2 years ago
Solved

DAX question

Hi,   I created a measure to calculate [Request] total for those "Non - Special" branches. It works ok for all branches, but not with the branch slicer, i.e, when I select a particular branch, the ...
Need Help
  • parry2k's avatar
    parry2k
    2 years ago

    spagad6263 try this:

     

    meas_Request_Branch = CALCULATE
(
    SUM(Data[Request]),
    KEEPFILTERS ( Data[Branch] <> "Special" )
)
parry2k's avatar
parry2k
Super User
2 years ago

spagad6263 try this:

 

meas_Request_Branch = CALCULATE
(
    SUM(Data[Request]),
    KEEPFILTERS ( Data[Branch] <> "Special" )
)