Cities fall under each quartile

[SivaMani]

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))

[v-lili6-msft]

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