Forum Discussion
Removefilter 2 columns
Hello, How do I use RemoveFilter to work with 2 columns. Here it works fine in below table. Filter pan: When I only filtered on FCB. But when I bring "Group" in th...
Anonymous , try like
Headcount All =
CALCULATE (
DISTINCTCOUNT( HC[_BIC_HEMPID] ),
allselected( HC[ETHNIC_GRP_TEXT])
)or
Headcount All =
CALCULATE (
DISTINCTCOUNT( HC[_BIC_HEMPID] ),
allselected( HC)
)
amitchandak
Super User
Super UserAnonymous , try like
Headcount All =
CALCULATE (
DISTINCTCOUNT( HC[_BIC_HEMPID] ),
allselected( HC[ETHNIC_GRP_TEXT])
)
or
Headcount All =
CALCULATE (
DISTINCTCOUNT( HC[_BIC_HEMPID] ),
allselected( HC)
)