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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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