Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
Solved! Go to Solution.
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!!
That's an issue in DAX QUERY view and won't affect any of your measures or any other areas
Appreciate your Kudos!!
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?
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!!
User | Count |
---|---|
53 | |
28 | |
19 | |
18 | |
14 |
User | Count |
---|---|
92 | |
86 | |
39 | |
24 | |
22 |