Forum Discussion
Post PartisanCalculate <> Not working as expected
Hi ERing ,
Thank you for reaching out to the Microsoft Fabric Community Forum regarding the issue you're facing.
After reviewing the screenshots provided, I attempted to replicate the issue locally, and everything appears to be working as expected. For your reference, I’m providing a document that may help you.
Additionally, please consider the following suggestions:
- Ensure that no additional filters are applied to your visual or report, as they might unintentionally exclude some rows.
- Double-check that the status values in your data precisely match the strings used in your DAX formula
I hope this helps resolve your issue. If so, kindly give us Kudos and consider marking this post as the solution to assist other members in finding the answer more quickly.
Super Userhow are the tables related?
Post PartisanThe tables are not related in my model.
- lbendlin
Quite impressive that you get any results at all then.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523