Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 (Monthly) = CALCULATE(DISTINCTCOUNT(donation_event[recipient_id]), donation_event[Week No.]=max(donation_event[Week No.]))
Its just to get a distinct count of the recipients when the week no. is equal to the max value for the week no column and I am getting the following error.
"A function 'MAX' has been used in a True/False expression that is used as a table filter expression. This is not allowed."
Not sure where I'm going wrong as the below works fine too.
Charities (Monthly) = CALCULATE(DISTINCTCOUNT(donation_event[recipient_id]), donation_event[Week No.]=20))
Thanks
Solved! Go to Solution.
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 !!!
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 !!!
Thanks. That works perfectly!
Welcome @kirwanm1
Kindly like the post if you think it has solved your problem 🙂
Table Example
Shop a | 6
Shop a | 6
Shop a | 7
Shop a | 7
Shop b | 5
Shop b | 5
Shop b | 6
Shop b | 6
Shop c | 5
Shop c | 7
Shop c | 7
Shop c | 7
Shop c returns 3
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
71 | |
37 | |
31 | |
26 |
User | Count |
---|---|
94 | |
50 | |
43 | |
40 | |
35 |