topic Re: How can I count on a multiple text filter in DAX Commands and Tips

How can I count on a multiple text filter

TeamCanada26__ — Wed, 28 Sep 2022 21:36:31 GMT

I am trying to count the number of "Other" leaves.

This returns 0, as we can't count on a multiple filter, any ideas as to how to resolve in a measure?

Count of Other LWOP =

CALCULATE(

COUNTA('Demographic'[Leave Type]),

'Demographic'[Leave Type] IN {

"Family Related and Personal Leave without Pay > Care and Nurturing LWOP",

"Family Related and Personal Leave without Pay > Maternity LWOP",

"Family Related and Personal Leave without Pay > Parental LWOP",

"Family Related and Personal Leave without Pay > Relocation of Spouse LWOP",

"Leave without Pay > Sick LWOP",

"Other Leave without Pay > Educational LWOP",

"Other Leave without Pay > Long-Term Disability LWOP",

"Other Leave without Pay > Other LWOP",

"Other Leave without Pay > Self Funded LWOP",

"Other Leave without Pay > Suspension/Disciplinary Action LWOP",

"Other Leave without Pay > Union Business LWOP"

}

)

Re: How can I count on a multiple text filter

Greg_Deckler — Wed, 28 Sep 2022 23:31:27 GMT

TeamCanada26__ Perhaps try:

Measure = VAR __Table = FILTER('Demographic',[Leave Type] IN { "Family Related and Personal Leave without Pay > Care and Nurturing LWOP", "Family Related and Personal Leave without Pay > Maternity LWOP", "Family Related and Personal Leave without Pay > Maternity LWOP", "Family Related and Personal Leave without Pay > Parental LWOP", "Family Related and Personal Leave without Pay > Parental LWOP", "Family Related and Personal Leave without Pay > Relocation of Spouse LWOP", "Leave without Pay > Sick LWOP", "Other Leave without Pay > Educational LWOP", "Other Leave without Pay > Long-Term Disability LWOP", "Other Leave without Pay > Other LWOP", "Other Leave without Pay > Self Funded LWOP", "Other Leave without Pay > Suspension/Disciplinary Action LWOP", "Other Leave without Pay > Union Business LWOP" } ) RETURN COUNTAX(__Table,[Leave Type])

Re: How can I count on a multiple text filter

TeamCanada26__ — Wed, 05 Oct 2022 11:25:15 GMT

Thank you!