Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Power BI DAX may be broken after this latest update. All of the sudden, filters are not working when using calculate.
I have a simple formula
Solved! Go to Solution.
@lcasey ,
Have you solved your issue by now? If you have, could you please help mark the correct answer to finish the thread? Your contribution will be much appreciated.
Regards,
Jimmy Tao
@lcasey ,
I've made a test on this, however I couldn't reproduce your issue, filter() works well on my side. Please update power bi desktop to the lastest version. In addtion, my power bi version is like below.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, why you don't use a SUM instead of SUMX in your formula.
Calculate(SUM('Cases'[CaseGAP]),FILTER(--------))
Maybe this give you more clarify about the issue.
Regards
Using SUM produces the same exact result. I beleive Power BI is completel;y broken now with this latest update. It makes no sense why filters are not working in a calculate.
@lcasey ,
Have you solved your issue by now? If you have, could you please help mark the correct answer to finish the thread? Your contribution will be much appreciated.
Regards,
Jimmy Tao
I did get it working, I just dont remember what it was I did. But the filters are working good now.
Thanks!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |