True/False DAX filter not working

[molegris]

Hi,

I converted my formula to output 0/1 and it works.  I can use it as a workaround but I still wonder if anybody knows why the True/False version is not working.  It is a Power BI limitation (bug?)

When the formula returns true/false it's not even possible to open the filter to set it up.  I tried deleting and reinserting many times and it never works.  (See image-1)  But by changing it to 1/0 it behaves perfectly.  (See image-2)

Thank you

--mo

[parry2k]

@molegris why not do this, change the last line to the following code:

__maxSessions = __globalMaxSessions

Check my latest blog post Year-2020, Pandemic, Power BI and Beyond to get a summary of my favourite Power BI feature releases in 2020

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[molegris]

Thank you but I've tried this too.  Same behavior: you can see the filter but it is impossible to set it.

According to @Fowmy  it is a known behavior.  I'm just hope Microsoft will eventually fix it!

[Fowmy · Accepted solution]

@molegris 

Yes, There TRUE/FALSE are not accepted, you need have either 1 or 0.

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂

Website YouTube  LinkedIn

[molegris]

Thank you for comfirming it. 

Do you know if Microsoft has documented it anywhere?  Do they consider this to be Working as documented or is it an Issue/Bug to be resolved ?