DAX Distinct Count of Count Rows Calculation

Question

Hey All,&nbsp;&nbsp;&nbsp; &nbsp;Having an issue when viewing qualified personnel. Some people have zero, they are indicated in a column as "No License", However when someone has a qualification, and for each of those qualifications, the same column will indicate "License". The issue I have when creating a measure, it counts all the times "License" is there, not simply the one time, so I can't give the answer to "How many people do we have with a license"&nbsp;COMPANY&nbsp; &nbsp; &nbsp; LAST NAME&nbsp; &nbsp; &nbsp;LICENSE&nbsp; &nbsp; &nbsp; QUALIFICATIONA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Garth&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; License&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;TruckA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Garth&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; License&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;VanB&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Vander&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; License&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;TruckC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Anders&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; No License&nbsp;D&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Dunn&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; License&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TruckD&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Clark&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;License&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TruckD&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Clark&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;License&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; VanSo when I do the Table using the Companies, and how many licensed personnel they have it should displayA&nbsp; &nbsp; &nbsp; &nbsp;1B&nbsp; &nbsp; &nbsp; &nbsp;1C&nbsp; &nbsp; &nbsp; &nbsp;0D&nbsp; &nbsp; &nbsp; &nbsp;2&nbsp;Any help is appreciated, I'm not sure how to use Distinct Count and Count Rows together, and using Filter doesn't seem to help either.&nbsp;

thejeswar · Accepted Answer

Hi&nbsp;TimsLanding&nbsp;,
You can try using the below DAX&nbsp;
Create a&nbsp;Calculated Measure&nbsp;as shown below
NoofLicenses = 
VAR Licenses = CALCULATE(DISTINCTCOUNT(Table1[Last Name]), Table1[License] = "License") 
RETURN
IF(ISBLANK(Licenses), 0, Licenses)
&nbsp;The Output looks as follows

&nbsp;
Regards,

Forum Discussion

DAX Distinct Count of Count Rows Calculation

2 Replies

Related content

DAX Calculation for Distinct Count

count distinct

Distinct Count

Distinct count

Average - Distinct Count