Forum Discussion

andybamber's avatar
andybamber
Icon for Helper III rankHelper III
5 years ago
Solved

DAX Measure - Keepfilters

Hello!

 

I have a report for company headcount. The organisation has 5 levels going from Domain at the top to cost centre at level 5. The report has an organisational slicer which thge user can then use to see the headcount at any of these levels.

 

We now have headcount budgets, but these are only set at the Domain level. I have a KPI visual and what I need to do is restrict Indicator (current headcount) to allways only show the Domain level headcount even if the user selects a level below. I wrote this measure thinking keepfilters would ensure this.

 

 Headcount_KPI = CALCULATE(DISTINCTCOUNT(SNAP_DWH_RES_RESOURCE[resource_key]),LASTDATE(SNAP_DWH_RES_RESOURCE[snaphot_stamp]),
KEEPFILTERS(DWH_ODF_Z_CC_OWNERS_LN[cc_domain] = "A" ||
DWH_ODF_Z_CC_OWNERS_LN[cc_domain] = "B" ||
DWH_ODF_Z_CC_OWNERS_LN[cc_domain] = "C" ||
DWH_ODF_Z_CC_OWNERS_LN[cc_domain] = "D" ||
DWH_ODF_Z_CC_OWNERS_LN[cc_domain] = "E" ||
DWH_ODF_Z_CC_OWNERS_LN[cc_domain] = "F" ||
DWH_ODF_Z_CC_OWNERS_LN[cc_domain] = "G" ||
DWH_ODF_Z_CC_OWNERS_LN[cc_domain] = "H" ||
DWH_ODF_Z_CC_OWNERS_LN[cc_domain] = "I" ||
DWH_ODF_Z_CC_OWNERS_LN[cc_domain] = "J"
))

 

But when a user selects a lower level this seems to be ignored at the headcount for the new level is displayed... Can anyone advise where I am going wrong?

 

Thanks

Andy