True value not showing in filter

[Anonymous]

Hello

I am currently using the following measure to determine if an individual is currently on leave (I have the start and end dates of their applications) and it is correctly returing a TRUE/FALSE value in the Data tab.

LeaveNow = IF(AND([StartDate]<=TODAY(),[EndDate]>=TODAY()),TRUE(),FALSE())

 

I then wanted to put that count onto a card and filter for just the True values.

 However when I try to apply a filter on the card the option for True is not showing

Any assistance with this issue would be greatly appreaciated

Thanks

[v-xiaotang]

Hi @Anonymous 

I just want to confirm if you resolved this issue? If yes, you can accept the answer helpful as the solution or share you method and accept it as solution, thanks for your contribution to improve Power BI.

If you need more help, please let me know.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[danextian]

Hi @Anonymous 

A measure is viewable only if used in a visual. Can you please share your pbix?