Distinct count with date parameter

[njxfoster]

Hi Guys

I want to create a distinct count for cancel note

These "Request from Management - pick up resource hours" should only be count once since it's all from the same date but different shift.

However, If I only use distinct count in this situation. "Request from Management - pick up resource hours" from other date will all count as only one note in total

Is there anyway I can count this cancel note also with parameter of different date so "Request from Management - pick up resource hours" from other date will count seperatly?

Thanks In advance.

[TheoC]

Hi @njxfoster 

Can you try the following measure:

DCount By Cat = CALCULATE ( DISTINCTCOUNT ( 'Table'[Cancel_Note] ) , ALLEXCEPT ( 'Table' , 'Table'[Date] ) )

If the filtering category changes (i.e. Date), you can just change it or you can add to it by adding a comma and 'Table'[Category2] after the 'Table'[Date]...

Hope this helps!

Theo 🙂

[V-lianl-msft · Accepted solution]

Hi @njxfoster ,

Try to create a measure like below:

Measure = 
var min_time = CALCULATE(MIN('Table'[Time]),ALLSELECTED('Table'[Time]))
return CALCULATE(DISTINCTCOUNT('Table'[Note]),FILTER('Table',min_time='Table'[Time]))

If I misunderstand what you mean, could you provide the results you expect?

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[TheoC]

Hi @njxfoster 

Can you try the following measure:

DCount By Cat = CALCULATE ( DISTINCTCOUNT ( 'Table'[Cancel_Note] ) , ALLEXCEPT ( 'Table' , 'Table'[Date] ) )

If the filtering category changes (i.e. Date), you can just change it or you can add to it by adding a comma and 'Table'[Category2] after the 'Table'[Date]...

Hope this helps!

Theo 🙂