Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

DISTINCT COUNT WITH FILTER

Hi, I am trying to create a measure that is going ot divide the total number of ditint rows by the total number of distint rows that are in the category "A" to see the % of rows that are category "A"...
Need Help
Show and Tell
Tutorial Requests
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

You will want to use DIVIDE()  to protect against cases of division by zero.

 

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523