Distinct Count help

Gi0vanna — Thu, 24 Oct 2024 18:32:43 GMT

Hello! Can someone help me with a strange issue that I'm having?

I would like to track active users vs non-active in a data set of conditions entered to display what percentage of each group is active. My table is a list of every single condition entered by username (and each username is in a group). There are rows with usernames with no condition information so that I can show this percentage of active vs non-active.

The issue that I am having, is that I was going to do a distinct count of usernames who have entered conditions divided by the distinct count of all usernames. They are in 2 different columns, and I have 2 different measures. For some reason, I am getting the same number for both. Example, Group1 has 23 members, but only 9 have entered conditions. My distinct count is showing 9 for both instead of 9 for one and 23 for the other.

Power BI even shows me that there are 23 at the bottom of the screen in the small description, but not in my measure.

These are my queries for both columns (usernames with conditions, and ALL usernames conditions or not)

Total Users = (DISTINCTCOUNT(Query1[UserName]))

Users with Conditions = DISTINCTCOUNT(Query1[UserName (Custom SQL Query)])

I have tried all sorts of things like this but get the same result:

Users with Conditions = CALCULATE(DISTINCTCOUNT(Query1[UserName (Custom SQL Query)]),NOT(ISBLANK(Query1[UserName (Custom SQL Query)])))

This was my really long way of asking, how do I get 23 to display in my table (from 1st snip)?

Thanks in advance!

Re: Distinct Count help

lbendlin — Thu, 24 Oct 2024 22:26:03 GMT

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.

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

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/1447523

topic Re: Distinct Count help in DAX Commands and Tips

Distinct Count help

Re: Distinct Count help