DAX FUNCTION FOR TIERS?

[Anonymous]

With the data that I have, is there a way to create a column that tiers the Gross Chargbacks in tiers of 20%? I want the highest dollar value to be placed in the first 20% and so on. These tiers should be represented by a score of 1,2,3,4 and 5, with the first 20% being a 1.

I also have a date table in which I am joing to, that has the fiscal years. I want each fiscal year to be tiered. In other words I do not want the entire table to be tiered at once, rather I want to have a 20% tiered projection, one fiscal year at a time. Is there a way to do this?

Agent_ID	Gross Chargebacks	Date of Chargeback
111	$997	7/1/2022
112	$755	7/1/2022
113	$481	8/1/2022
114	$432	8/1/2022
115	$560	8/1/2022

Date	Fiscal Year
7/1/2022	FY2022
8/1/2022	FY 2023
9/1/2022	FY 2023
10/1/2022	FY 2023

[amitchandak · Accepted solution]

@Anonymous , Not very clear, check if percentile can help

https://blog.enterprisedna.co/implementing-80-20-logic-in-your-power-bi-analysis/
https://forum.enterprisedna.co/t/testing-the-pareto-principle-80-20-rule-in-power-bi-w-dax/459

or TOP

TOPN: https://youtu.be/QIVEFp-QiOk