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%

Hi unnijoy , Let me know if this is what you need.' Please find the .pbix file. https://drive.google.com/open?id=1i62ZQT16-NPKgvYJgoCeNXhOe0bHtOwS Regards,Harsh NathaniDid I answer your question? Mark my post as a solution! Appreciate with a Kudos!!

unnijoy

Post Prodigy

6 years ago

Solved

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".

MONTH	Team Manager	Country	Att%
01-02-2020	Rothery, Dylan	AUSTRALIA	0%
01-02-2020	Van Zutphen, Michael	AUSTRALIA	0%
01-02-2020	Coward, Thomas	AUSTRALIA	0%
01-02-2020	Rafter, James	AUSTRALIA	0%
01-02-2020	Wake, Cameron	AUSTRALIA	0%
01-02-2020	Farquhar, Tayler	AUSTRALIA	0%
01-02-2020	Peters, Stacey	AUSTRALIA	0%
01-02-2020	Dodge, Timothy	AUSTRALIA	0%
01-02-2020	Holden-Schulz, Brooke	AUSTRALIA	0%
01-02-2020	Gaerlan, Manuel	AUSTRALIA	0%
01-02-2020	Clifton, Jacqueline	AUSTRALIA	0%
01-02-2020	Moncrieff, Lisa	AUSTRALIA	0%
01-02-2020	Flello, Kelly Denise	AUSTRALIA	0%
01-02-2020	Kerr, Michael	AUSTRALIA	0%
01-02-2020	Tamaiparea, Kimiora	AUSTRALIA	0%
01-02-2020	Glasse, Shannon	AUSTRALIA	0%
01-02-2020	Leeson, Tricia	AUSTRALIA	0%
01-02-2020	Berry, Susan	AUSTRALIA	0%
01-02-2020	Watkinson, Casey	AUSTRALIA	0%
01-02-2020	Neild, David	AUSTRALIA	0%
01-02-2020	Nyamayaro, Munyaradzi	AUSTRALIA	0%
01-02-2020	Schoeman, Dominique	AUSTRALIA	0%
01-02-2020	Aho, Talitha	AUSTRALIA	0%
01-02-2020	Slattery, Thomas	AUSTRALIA	5%
01-02-2020	Auboire, Ashley	AUSTRALIA	6%
01-02-2020	Baxter, Aurora	AUSTRALIA	6%
01-02-2020	Sgualdino, Adriano	AUSTRALIA	6%
01-02-2020	Dollin, Ellen	AUSTRALIA	7%
01-02-2020	Subbaroo, Punetha	AUSTRALIA	9%
01-02-2020	Harwood, Justin	AUSTRALIA	9%
01-02-2020	Woodfield, Lauren	AUSTRALIA	12%
01-02-2020	Moghaddam, Anthony	AUSTRALIA	12%
01-02-2020	Lyall-Lawrence, CNedra	AUSTRALIA	15%
01-02-2020	Hosking-Thompson, Kelsey	AUSTRALIA	16%
01-02-2020	Najarro, Gabriel	AUSTRALIA	20%
01-02-2020	Skinner, Krista	AUSTRALIA	24%
01-02-2020	Degoumois, Jacqueline	AUSTRALIA	24%
01-02-2020	John Peter, Nirosan Jude	AUSTRALIA	27%
01-02-2020	Munday, Karen	AUSTRALIA	39%
01-02-2020	Duarte, Bruno Vieira	BRAZIL	23%
01-02-2020	Silva, Tamara	BRAZIL	5%
01-02-2020	Silva, Ivan Cirino	BRAZIL	10%
01-02-2020	Ferlini, Thiago Do Nascimento	BRAZIL	7%
01-02-2020	Bonifazio, Anderson	BRAZIL	34%
01-02-2020	Ceccon, Dayane	BRAZIL	5%
01-02-2020	Silva, Haschle Nascimento	BRAZIL	0%
01-02-2020	Santos, Albert Wesley Oliveira	BRAZIL	67%
01-02-2020	Da Silva, Gabriel Lima	BRAZIL	0%
01-02-2020	Pelinson, Leonardo	BRAZIL	0%
01-02-2020	Santana, Evair	BRAZIL	23%
01-02-2020	CAVALCANTE, CLAUDIA DA SILVA	BRAZIL	7%
01-02-2020	Lima, Liliane Maria	BRAZIL	0%
01-02-2020	Pereira, Juliana Alves	BRAZIL	1%
01-02-2020	Faber, Larissa Vieira Da Silva	BRAZIL	7%
01-02-2020	Gomes, Leonardo Jose	BRAZIL	0%
01-02-2020	Menezes, Felipe Alexandre	BRAZIL	5%
01-02-2020	De Brito, Thiago Lazaro Correia	BRAZIL	0%
01-02-2020	Pena, Bruno	BRAZIL	0%
01-03-2020	Rothery, Dylan	AUSTRALIA	0%
01-03-2020	Van Zutphen, Michael	AUSTRALIA	0%
01-03-2020	Coward, Thomas	AUSTRALIA	0%
01-03-2020	Rafter, James	AUSTRALIA	3%
01-03-2020	Wake, Cameron	AUSTRALIA	0%
01-03-2020	Farquhar, Tayler	AUSTRALIA	0%
01-03-2020	Peters, Stacey	AUSTRALIA	0%
01-03-2020	Dodge, Timothy	AUSTRALIA	0%
01-03-2020	Holden-Schulz, Brooke	AUSTRALIA	56%
01-03-2020	Gaerlan, Manuel	AUSTRALIA	0%
01-03-2020	Clifton, Jacqueline	AUSTRALIA	7%
01-03-2020	Moncrieff, Lisa	AUSTRALIA	0%
01-03-2020	Flello, Kelly Denise	AUSTRALIA	0%
01-03-2020	Kerr, Michael	AUSTRALIA	0%
01-03-2020	Tamaiparea, Kimiora	AUSTRALIA	67%
01-03-2020	Glasse, Shannon	AUSTRALIA	8%
01-03-2020	Leeson, Tricia	AUSTRALIA	0%
01-03-2020	Berry, Susan	AUSTRALIA	45%
01-03-2020	Watkinson, Casey	AUSTRALIA	0%
01-03-2020	Neild, David	AUSTRALIA	0%
01-03-2020	Nyamayaro, Munyaradzi	AUSTRALIA	8%
01-03-2020	Schoeman, Dominique	AUSTRALIA	0%
01-03-2020	Aho, Talitha	AUSTRALIA	0%
01-03-2020	Slattery, Thomas	AUSTRALIA	5%
01-03-2020	Auboire, Ashley	AUSTRALIA	6%
01-03-2020	Baxter, Aurora	AUSTRALIA	6%
01-03-2020	Sgualdino, Adriano	AUSTRALIA	67%
01-03-2020	Dollin, Ellen	AUSTRALIA	7%
01-03-2020	Subbaroo, Punetha	AUSTRALIA	54%
01-03-2020	Harwood, Justin	AUSTRALIA	34%
01-03-2020	Woodfield, Lauren	AUSTRALIA	12%
01-03-2020	Moghaddam, Anthony	AUSTRALIA	32%
01-03-2020	Lyall-Lawrence, CNedra	AUSTRALIA	21%
01-03-2020	Hosking-Thompson, Kelsey	AUSTRALIA	16%
01-03-2020	Najarro, Gabriel	AUSTRALIA	20%
01-03-2020	Skinner, Krista	AUSTRALIA	24%
01-03-2020	Degoumois, Jacqueline	AUSTRALIA	43%
01-03-2020	John Peter, Nirosan Jude	AUSTRALIA	27%
01-03-2020	Munday, Karen	AUSTRALIA	39%
01-03-2020	Duarte, Bruno Vieira	BRAZIL	23%
01-03-2020	Silva, Tamara	BRAZIL	5%
01-03-2020	Silva, Ivan Cirino	BRAZIL	10%
01-03-2020	Ferlini, Thiago Do Nascimento	BRAZIL	7%
01-03-2020	Bonifazio, Anderson	BRAZIL	4%
01-03-2020	Ceccon, Dayane	BRAZIL	5%
01-03-2020	Silva, Haschle Nascimento	BRAZIL	0%
01-03-2020	Santos, Albert Wesley Oliveira	BRAZIL	67%
01-03-2020	Da Silva, Gabriel Lima	BRAZIL	0%
01-03-2020	Pelinson, Leonardo	BRAZIL	7%
01-03-2020	Santana, Evair	BRAZIL	23%
01-03-2020	CAVALCANTE, CLAUDIA DA SILVA	BRAZIL	7%
01-03-2020	Lima, Liliane Maria	BRAZIL	0%
01-03-2020	Pereira, Juliana Alves	BRAZIL	1%
01-03-2020	Faber, Larissa Vieira Da Silva	BRAZIL	7%
01-03-2020	Gomes, Leonardo Jose	BRAZIL	5%
01-03-2020	Menezes, Felipe Alexandre	BRAZIL	5%
01-03-2020	De Brito, Thiago Lazaro Correia	BRAZIL	12%
01-03-2020	Pena, Bruno	BRAZIL	0%

Need Help

Anonymous
6 years ago
Hi unnijoy ,

Let me know if this is what you need.
'

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

Forum Discussion

Quartile calculation

4 Replies

Related content

Quartiles Calculated Columns

Quartile Calculation - Incorrect values

Quartile Calculation

Dynamic quartile calculations using measures

quartile ranking