Distinct Count based on max value

Hey Everyone, I'm having a little trouble with filtering by the maximum value of a month no. and wondering if anyone knows where I'm going wrong. I have the following formula Charities (Month...

Need Help

prateekraina

9 years ago

Edited

Hi kirwanm1,

Try this DAX:

Charities (Monthly) = CALCULATE(DISTINCTCOUNT(donation_event[recipient_id]), FILTER(donation_event,donation_event[Week No.]=max(donation_event[Week No.])))

There might some braces missing, just correct that, it should work.

Thanks !!!

Forum Discussion

Distinct Count based on max value

Related content

count distinct

Distinct Count

Count Distinct Values based on another column in Power Query

Distinct count

DAX Calculation for Distinct Count