Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Anonymous
Not applicable

Calculating Quartile Based on values in visual

I have a table which has some zip codes and their corresponding population. I am using a visual where i want to show  which zip falls under which quartile based on their population. The zips showing in that visual are filtered based on a slicer. So instead of using the population within the whole table, I want the quartile to be calculated based on population of ONLY the zips within that visual. This is the formula i used but I dont think it is showing the right data

 

Q Population = var high = PERCENTILE.INC('Calculated'[POPULATION],.75) Var mid = PERCENTILE.INC('Calculated'[POPULATION],.50) var low = PERCENTILE.INC('Calculated'[POPULATION],.25) return if(('Calculated'[POPULATION])<= low, "Q1", IF(AND(('Calculated'[POPULATION])<= mid,('Calculated'[POPULATION])>low), "Q2", if(and(('Calculated'[POPULATION]) <=high,('Calculated'[POPULATION])> mid ), "Q3","Q4")))

 

2 REPLIES 2
Anonymous
Not applicable

@Jihwan_Kim  You understood my problem right and I am able to understand the approach you are taking but i think because of my data size or maybe because of the number of other criterias, it is taking time to create rank.

 

Jihwan_Kim
Super User
Super User

Hi, @Anonymous 

Please correct me if I wrongly understood your question.

please check the below picture and the sample pbix file's link down below, whether it is what you are looking for.

 

all measures are in the sample pbix file.

 

Picture1.png

 

 

https://www.dropbox.com/s/2alfic9ybnywva8/shalu.pbix?dl=0 

 

 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.


If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.