Forum Discussion

unnijoy's avatar
unnijoy
Icon for Post Prodigy rankPost Prodigy
6 years ago
Solved

Perfomance based on Quartile

I have the attriton Data based on Team Manager and country. I need to find the quartile and based on that we need to see whcih quartile the TM falls under. Fotr this i need a formula that will calcul...
Need Help
unnijoy's avatar
unnijoy
Icon for Post Prodigy rankPost Prodigy
6 years ago

Anonymous 

 

Rather than creating calculated column can we create measures for finding MIN,MAX,25th,50th&75th quartile and use based on this measuse can we catogorise Team manager like top,Bottom,50th and 75th Quartile.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi unnijoy ,

 

Pbix attached.

 

https://drive.google.com/open?id=1c_4sDlGxYnUrJ9epuyN4u6qvJyCR97q6

 

Remove SUM in Visualization view and change it to Don't Summarize to get the correct results. Also, find the single card as required.

 

Regards,

Harsh Nathani

 

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

  • unnijoy's avatar
    unnijoy
    Icon for Post Prodigy rankPost Prodigy
    6 years ago

    hi Anonymous 

     

    Thanka a lot ... It is working file. You are amazing.