Help with function percentile.

[andrelopes2711]

Hello, good evening, I need to create two table graphs with quartile information based on agent evaluations and by category in each table, but showing the number of agents that are in each quartile and can change depending on the date filter chosen, but isn't working, could you help me where I'm going wrong and how to fix it to make it work? 

I used the percentile function with summarized and then another measure to count the agents within the percetile, I don´t know is the best way...

Thanks for help!

QA_Alter_Quartil_Forum.pbix

Base Quartil.xlsx

[Anonymous]

Hi @andrelopes2711 ,

The file you provided cannot be opened. Please provide your data in the form of a table or excel workbook. Also, please attach your desired results.

Best regards,

Mengmeng Li

[andrelopes2711]

Hello, I edited and shared the base and the pbix link again, thanks for the help.

[Anonymous]

Hi @andrelopes2711 ,

For some reason the link you provided still does not open, you can refer to this link to provide data and files for your question. How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Best regards,

Mengmeng Li