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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
unnijoy
Post Partisan
Post Partisan

Quartile calculation

I have the attriton data country wise. I need to create a measure that will calculate the quartile (Min,25th,50th,75th&Max) and based on the quartile it will catogarise the tema manger.

attriton%>=Min &<=25th="Top"/,Attriton%>25th&<=50th="50th"/,attriton%>50th&<=75th="75th"/else "Bottom".

 

MONTHTeam ManagerCountryAtt%
01-02-2020Rothery, Dylan AUSTRALIA0%
01-02-2020Van Zutphen, Michael AUSTRALIA0%
01-02-2020Coward, Thomas AUSTRALIA0%
01-02-2020Rafter, James AUSTRALIA0%
01-02-2020Wake, Cameron AUSTRALIA0%
01-02-2020Farquhar, Tayler AUSTRALIA0%
01-02-2020Peters, Stacey AUSTRALIA0%
01-02-2020Dodge, Timothy AUSTRALIA0%
01-02-2020Holden-Schulz, Brooke AUSTRALIA0%
01-02-2020Gaerlan, Manuel AUSTRALIA0%
01-02-2020Clifton, Jacqueline AUSTRALIA0%
01-02-2020Moncrieff, Lisa AUSTRALIA0%
01-02-2020Flello, Kelly DeniseAUSTRALIA0%
01-02-2020Kerr, Michael AUSTRALIA0%
01-02-2020Tamaiparea, Kimiora AUSTRALIA0%
01-02-2020Glasse, Shannon AUSTRALIA0%
01-02-2020Leeson, Tricia AUSTRALIA0%
01-02-2020Berry, Susan AUSTRALIA0%
01-02-2020Watkinson, Casey AUSTRALIA0%
01-02-2020Neild, David AUSTRALIA0%
01-02-2020Nyamayaro, Munyaradzi AUSTRALIA0%
01-02-2020Schoeman, Dominique AUSTRALIA0%
01-02-2020Aho, Talitha AUSTRALIA0%
01-02-2020Slattery, Thomas AUSTRALIA5%
01-02-2020Auboire, Ashley AUSTRALIA6%
01-02-2020Baxter, Aurora AUSTRALIA6%
01-02-2020Sgualdino, Adriano AUSTRALIA6%
01-02-2020Dollin, Ellen AUSTRALIA7%
01-02-2020Subbaroo, Punetha AUSTRALIA9%
01-02-2020Harwood, Justin AUSTRALIA9%
01-02-2020Woodfield, Lauren AUSTRALIA12%
01-02-2020Moghaddam, Anthony AUSTRALIA12%
01-02-2020Lyall-Lawrence, CNedra AUSTRALIA15%
01-02-2020Hosking-Thompson, Kelsey AUSTRALIA16%
01-02-2020Najarro, Gabriel AUSTRALIA20%
01-02-2020Skinner, Krista AUSTRALIA24%
01-02-2020Degoumois, Jacqueline AUSTRALIA24%
01-02-2020John Peter, Nirosan Jude AUSTRALIA27%
01-02-2020Munday, Karen AUSTRALIA39%
01-02-2020Duarte, Bruno VieiraBRAZIL23%
01-02-2020Silva, Tamara BRAZIL5%
01-02-2020Silva, Ivan CirinoBRAZIL10%
01-02-2020Ferlini, Thiago Do NascimentoBRAZIL7%
01-02-2020Bonifazio, Anderson BRAZIL34%
01-02-2020Ceccon, Dayane BRAZIL5%
01-02-2020Silva, Haschle NascimentoBRAZIL0%
01-02-2020Santos, Albert Wesley OliveiraBRAZIL67%
01-02-2020Da Silva, Gabriel LimaBRAZIL0%
01-02-2020Pelinson, Leonardo BRAZIL0%
01-02-2020Santana, Evair BRAZIL23%
01-02-2020CAVALCANTE, CLAUDIA DA SILVA BRAZIL7%
01-02-2020Lima, Liliane MariaBRAZIL0%
01-02-2020Pereira, Juliana AlvesBRAZIL1%
01-02-2020Faber, Larissa Vieira Da SilvaBRAZIL7%
01-02-2020Gomes, Leonardo JoseBRAZIL0%
01-02-2020Menezes, Felipe AlexandreBRAZIL5%
01-02-2020De Brito, Thiago Lazaro CorreiaBRAZIL0%
01-02-2020Pena, Bruno BRAZIL0%
01-03-2020Rothery, Dylan AUSTRALIA0%
01-03-2020Van Zutphen, Michael AUSTRALIA0%
01-03-2020Coward, Thomas AUSTRALIA0%
01-03-2020Rafter, James AUSTRALIA3%
01-03-2020Wake, Cameron AUSTRALIA0%
01-03-2020Farquhar, Tayler AUSTRALIA0%
01-03-2020Peters, Stacey AUSTRALIA0%
01-03-2020Dodge, Timothy AUSTRALIA0%
01-03-2020Holden-Schulz, Brooke AUSTRALIA56%
01-03-2020Gaerlan, Manuel AUSTRALIA0%
01-03-2020Clifton, Jacqueline AUSTRALIA7%
01-03-2020Moncrieff, Lisa AUSTRALIA0%
01-03-2020Flello, Kelly DeniseAUSTRALIA0%
01-03-2020Kerr, Michael AUSTRALIA0%
01-03-2020Tamaiparea, Kimiora AUSTRALIA67%
01-03-2020Glasse, Shannon AUSTRALIA8%
01-03-2020Leeson, Tricia AUSTRALIA0%
01-03-2020Berry, Susan AUSTRALIA45%
01-03-2020Watkinson, Casey AUSTRALIA0%
01-03-2020Neild, David AUSTRALIA0%
01-03-2020Nyamayaro, Munyaradzi AUSTRALIA8%
01-03-2020Schoeman, Dominique AUSTRALIA0%
01-03-2020Aho, Talitha AUSTRALIA0%
01-03-2020Slattery, Thomas AUSTRALIA5%
01-03-2020Auboire, Ashley AUSTRALIA6%
01-03-2020Baxter, Aurora AUSTRALIA6%
01-03-2020Sgualdino, Adriano AUSTRALIA67%
01-03-2020Dollin, Ellen AUSTRALIA7%
01-03-2020Subbaroo, Punetha AUSTRALIA54%
01-03-2020Harwood, Justin AUSTRALIA34%
01-03-2020Woodfield, Lauren AUSTRALIA12%
01-03-2020Moghaddam, Anthony AUSTRALIA32%
01-03-2020Lyall-Lawrence, CNedra AUSTRALIA21%
01-03-2020Hosking-Thompson, Kelsey AUSTRALIA16%
01-03-2020Najarro, Gabriel AUSTRALIA20%
01-03-2020Skinner, Krista AUSTRALIA24%
01-03-2020Degoumois, Jacqueline AUSTRALIA43%
01-03-2020John Peter, Nirosan Jude AUSTRALIA27%
01-03-2020Munday, Karen AUSTRALIA39%
01-03-2020Duarte, Bruno VieiraBRAZIL23%
01-03-2020Silva, Tamara BRAZIL5%
01-03-2020Silva, Ivan CirinoBRAZIL10%
01-03-2020Ferlini, Thiago Do NascimentoBRAZIL7%
01-03-2020Bonifazio, Anderson BRAZIL4%
01-03-2020Ceccon, Dayane BRAZIL5%
01-03-2020Silva, Haschle NascimentoBRAZIL0%
01-03-2020Santos, Albert Wesley OliveiraBRAZIL67%
01-03-2020Da Silva, Gabriel LimaBRAZIL0%
01-03-2020Pelinson, Leonardo BRAZIL7%
01-03-2020Santana, Evair BRAZIL23%
01-03-2020CAVALCANTE, CLAUDIA DA SILVA BRAZIL7%
01-03-2020Lima, Liliane MariaBRAZIL0%
01-03-2020Pereira, Juliana AlvesBRAZIL1%
01-03-2020Faber, Larissa Vieira Da SilvaBRAZIL7%
01-03-2020Gomes, Leonardo JoseBRAZIL5%
01-03-2020Menezes, Felipe AlexandreBRAZIL5%
01-03-2020De Brito, Thiago Lazaro CorreiaBRAZIL12%
01-03-2020Pena, Bruno BRAZIL0%

 

1 ACCEPTED SOLUTION
harshnathani
Community Champion
Community Champion

Hi @unnijoy ,

 

Let me know if this is what you need.

'123.JPG

 

 

Please find the .pbix file.

 

https://drive.google.com/open?id=1i62ZQT16-NPKgvYJgoCeNXhOe0bHtOwS

 

Regards,

Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!!

View solution in original post

4 REPLIES 4
harshnathani
Community Champion
Community Champion

Hi @unnijoy ,

 

Let me know if this is what you need.

'123.JPG

 

 

Please find the .pbix file.

 

https://drive.google.com/open?id=1i62ZQT16-NPKgvYJgoCeNXhOe0bHtOwS

 

Regards,

Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!!

Anonymous
Not applicable

hi @harshnathani 

i think your answer is what i need now, but i colud not reach your solution. can you please reshare it?

amitchandak
Super User
Super User

@unnijoy ,

refer this

https://sqldusty.com/2018/08/31/calculating-quartiles-with-dax-and-power-bi/

 

and the chart

https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa104380831

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
vanessafvg
Super User
Super User

does this help?  https://sqldusty.com/2018/08/31/calculating-quartiles-with-dax-and-power-bi/

 

you can also use the box and whisker charts from the customer visualisations





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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