Forum Discussion
Cities fall under each quartile
Hello,
I'm looking for a solution to find the cities on each quartile based on Discharge Count.
I referred this thread but it is not working in my case. Kindly assist me.
Here are the measures I used,
Measure = PERCENTILE.INC(Merge1[DC],0.25)
Quartile 1st =
VAR Q1 = [Measure]
Return
CALCULATE(SUM(Merge1[DC]),FILTER(ALL(Merge1),Merge1[DC]>=Q1))
1 Reply
hi, SivaMani
Sample data would help tremendously. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
And you may try to adjust
Measure =CALCULATE(PERCENTILE.INC(Merge1[DC],0.25), ALLSELECTED(Merge1))
Best Regards,
Lin
