DAX Measure - Keepfilters

[andybamber]

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

[AnkitKukreja · Accepted solution]

Hi @andybamber 

Use remove filters instead, what all does is ignore filters from that table and you can choose particular column instead of table as well. 

Please refer to below link.

https://www.youtube.com/watch?v=9qKe66uBce8

Thanks,

Ankit

[andybamber]

perfect, thanks Ankit!