Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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% |
Solved! Go to Solution.
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!!
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!!
i think your answer is what i need now, but i colud not reach your solution. can you please reshare it?
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
Proud to be a Super User!
User | Count |
---|---|
131 | |
71 | |
70 | |
58 | |
54 |
User | Count |
---|---|
194 | |
95 | |
65 | |
62 | |
53 |