Forum Discussion

kirwanm1's avatar
kirwanm1
Frequent Visitor
9 years ago
Solved

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's avatar
    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 !!!

prateekraina's avatar
prateekraina
Memorable Member
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 !!!

kirwanm1's avatar
kirwanm1
Frequent Visitor
9 years ago

Thanks. That works perfectly!


  • prateekraina's avatar
    prateekraina
    Memorable Member
    9 years ago

    Welcome kirwanm1 
    Kindly like the post if you think it has solved your problem :)