Forum Discussion

Justas4478's avatar
Justas4478
Icon for Post Prodigy rankPost Prodigy
2 years ago
Solved

Filtering measures with slicers

Hi, I have this measure:  Hours for Absence = CALCULATE(     SUM('System Work Hours'[Hours Total]),     'System Data'[Absence] IN {         "Authorised Absence",         "Bank Holiday",      ...
Need Help
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    2 years ago

    Justas4478 , I really do not know you need filter in this case. But trylike

     

    Hours for Absence =
    CALCULATE(
    SUM('System Work Hours'[Hours Total]),
    Filter( 'System Data', 'System Data'[Absence] IN {
    "Authorised Absence",
    "Bank Holiday",
    "Holiday",
    "Maternity/Paternity",
    "Sickness",
    "Unauthorised"
    }
    ))

     

    if it works - Difference in filtering data in CALCULATE with and without FILTER? - https://youtu.be/KDcmzwgPvXQ

     

    Ideally this should work

    SUM('System Work Hours'[Hours Total])

     

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

Justas4478 , I really do not know you need filter in this case. But trylike

 

Hours for Absence =
CALCULATE(
SUM('System Work Hours'[Hours Total]),
Filter( 'System Data', 'System Data'[Absence] IN {
"Authorised Absence",
"Bank Holiday",
"Holiday",
"Maternity/Paternity",
"Sickness",
"Unauthorised"
}
))

 

if it works - Difference in filtering data in CALCULATE with and without FILTER? - https://youtu.be/KDcmzwgPvXQ

 

Ideally this should work

SUM('System Work Hours'[Hours Total])