COUNT DISTINCT

Question

Hi&nbsp;&nbsp;I am new to PBI as our company has long since used Qlikview but transitioning to PBI.&nbsp;I have spent a decent amount of time trying to figure this one out and while I am narrowing in on the answer I am either getting the wrong answer or errors.&nbsp;I have 4 relebant fields&nbsp;Worker , Approval Date, Expense ID, Amount&nbsp;I am using a table and want to show Worker, Sum Amount by Approval Date Year and Distinct Count of Expense ID.&nbsp;Sum Amount by Year is done.&nbsp;Count Distinct Expense ID's is my problem= If the Worker has no claims in the Year the Count is 1 not zero.&nbsp;Any thought that could help? I have tried various add column options and DISTINCYCOUNTNOBLANKS.&nbsp;Thanks in advance,&nbsp;Rob&nbsp;&nbsp;&nbsp;

bhanu_gautam · Accepted Answer

racer25&nbsp;You need to create a measure that calculates the distinct count of Expense IDs for each worker and year, and handles cases where there are no claims correctly.
&nbsp;
daxDistinctExpenseCount = VAR DistinctCount = DISTINCTCOUNT('YourTable'[Expense ID])RETURNIF(DistinctCount = BLANK(), 0, DistinctCount)

Forum Discussion

COUNT DISTINCT

2 Replies

Related content

count distinct

Distinct Count

Distinct count

DAX Calculation for Distinct Count

Average - Distinct Count