Forum Discussion

molegris's avatar
molegris
Icon for Advocate IV rankAdvocate IV
5 years ago
Solved

True/False DAX filter not working

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

Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    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

4 Replies

  • Fowmy's avatar
    Fowmy
    Icon for Super User rankSuper User
    5 years ago

    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's avatar
      molegris
      Icon for Advocate IV rankAdvocate IV
      5 years ago

      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 ?

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    5 years ago

    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's avatar
      molegris
      Icon for Advocate IV rankAdvocate IV
      5 years ago

      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!