topic Re: Is the output of TRUE() and FALSE() expected to be blank? (DAX Queries BUG?) in DAX Commands and Tips

Is the output of TRUE() and FALSE() expected to be blank? (DAX Queries BUG?)

F_Fitti — Thu, 11 Jan 2024 01:40:51 GMT

This post will potentially look like a stupid post/question, and I apologize in advance if it turns out I'm simply making an ignorant mistake here. I'm running Power BI Desktop December 2023.

I'm writing some logic in DAX measures using IF. Some of these measures are complex and not outputting the expected result. As troubleshoot step, I started breaking them down and testing each smaller segment individually, and noticed blank results every time my IF condition was expected to TRUE according to my data.

It got to the point where I was comparing columns to themselves (so a IF TRUE = TRUE type of situation) just to test the IF formula itself, and still got blank results in my measures. So I went to the new DAX Queries tab to run the simplest test I could think of:

EVALUATE

{

( IF(1 = 1, TRUE(), FALSE()) ) --> 1 =1, I expect TRUE as output

, ( IF(1 = 0, TRUE(), FALSE()) ) --> 1 is not 0, I expect FALSE as output

}

My expectation was to get TRUE in the first IF and FALSE in the second IF, but instead I got blank on both (screenshot below). Is this the expected output of both TRUE() and FALSE()? Shouldn't I get TRUE and FALSE as an output instead?

Re: Is the output of TRUE() and FALSE() expected to be blank? (DAX Queries BUG?)

VahidDM — Thu, 11 Jan 2024 02:57:20 GMT

Hey F_Fitti

That's a known issue and will be fixed in the next update.

BTW, if you test that on Dax Studio, you will get the right result.

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

Appreciate your Kudos!!

LinkedIn | Twitter | Blog | YouTube

Re: Is the output of TRUE() and FALSE() expected to be blank? (DAX Queries BUG?)

F_Fitti — Thu, 11 Jan 2024 03:08:46 GMT

Thank you so much for the super fast answer! Do you know where to find more information about this issue?

I'm wondering if this issue means that any of my measures could suddenly result incorrectly out of the blue (in content already published in the service)?

And also trying to determine whether this issue means all measures/logic that rely on IF statements resulting to either TRUE or FALSE will not work properly for now, or whether it's just an issue in the sense that the output on the screen is blank but the logic behind the evaluation itself is working as expected. Would you happen to know?

Re: Is the output of TRUE() and FALSE() expected to be blank? (DAX Queries BUG?)

VahidDM — Thu, 11 Jan 2024 03:55:20 GMT

That's an issue in DAX QUERY view and won't affect any of your measures or any other areas

Appreciate your Kudos!!

LinkedIn | Twitter | Blog | YouTube