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.
I have a table of products and a table of outputs, and I have a measure that counts the number of distinct outputs per product. It's important that if there are no outputs for a particular product, 0 is shown, so the measure is:
MyMeasure = IF(ISBLANK(DISTINCTCOUNT(Output[id])),0,DISTINCTCOUNT(Output[id]))
I now want to be able to filter the list of products shown. I have a table that joins to the Products table with the columns of data that I want to use to filter.
However, when I try and do this, every product still shows -- and the above measure shows 0 for everything except what I've selected. I think this is because the IF... syntax overrides the filter's attempt to filter things out.
How can I fix this? I see this similar question but that's for dates -- this is categorical data. Filters does not work when +0 is added to remove blanks
This also doesn't work https://community.fabric.microsoft.com/t5/Desktop/Need-to-replace-blank-with-zero-but-also-be-able-t...
Thank you!
MyMeasure = IF(ISBLANK(DISTINCTCOUNT(Output[id])),0,DISTINCTCOUNT(Output[id]))
can be refactored as
MyMeasure = COALESCE(DISTINCTCOUNT(Output[id]),0)
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
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 |
---|---|
106 | |
97 | |
75 | |
63 | |
62 |
User | Count |
---|---|
139 | |
104 | |
104 | |
80 | |
66 |