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 number doesn't change. I am sure there is issue with my measure below. Any suggestions? Sorry, I am new to DAX.

Thanks

 

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

 

Need Help
  • parry2k's avatar
    parry2k
    2 years ago

    spagad6263 try this:

     

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

5 Replies

  • parry2k's avatar
    parry2k
    Super User
    2 years ago

    spagad6263 try this:

     

    meas_Request_Branch = CALCULATE
(
    SUM(Data[Request]),
    KEEPFILTERS ( Data[Branch] <> "Special" )
)
  • spagad6263's avatar
    spagad6263
    Post Patron
    2 years ago

    Thanks and this is exactly what I need.

    Can you have a quick explanation about what below does?
    KEEPFILTERS ( Data[Branch] <> "Special" )