undefinedDynamic Threshold Setting for Pareto Analysis Using Parameters

[sugar_sugar]

I am creating a Pareto chart in Power BI. I have created a new column using the following DAX expressions:

Pareto = 
VAR ranking = RANKX('Sheet1','Sheet1'[Sales by Product])
VAR runningsum = SUMX(TOPN(ranking,'Sheet1','Sheet1'[Sales by Product],DESC),'Sheet1'[Sales by Product])
VAR total = CALCULATE(SUM('Sheet1'[Sales by Product]),ALL('Sheet1'))
RETURN DIVIDE(runningsum,total)

ABC Rank = 
IF('Sheet1'[Pareto] <= 0.8,"A",
IF('Sheet1'[Pareto] <= 0.9,"B","C"))

Next, I want to adjust the thresholds for ABC Rank using parameters so that they can be dynamically adjusted.

However, I am having trouble getting this to work properly using the new parameter feature in the Modeling tab.

How can I achieve this?

[sugar_sugar]

Thank you for your response.
I have attached the sample data I am using.
Best regards.

Product ID	Sales by Product	Pareto
A101	4315367	10.47%
A102	4017203	20.21%
A103	2728250	26.82%
A104	2393032	32.63%
A105	2025170	37.54%
A106	1939256	42.24%
A107	1684559	46.33%
A108	1376930	49.67%
A109	1344102	52.92%
A110	1296414	56.07%
A111	1141396	58.84%
A112	1034513	61.35%
A113	949620	63.65%
A114	895013	65.82%
A115	890820	67.98%
A116	736324	69.76%
A117	693144	71.45%
A118	666267	73.06%
A119	659629	74.66%
A120	659563	76.26%
A121	609166	77.74%
A122	587860	79.16%
A123	549414	80.50%
A124	534259	81.79%
A125	522458	83.06%
A126	471520	84.20%
A127	456031	85.31%
A128	440890	86.38%
A129	434803	87.43%
A130	423081	88.46%
A131	417105	89.47%
A132	386868	90.41%
A133	371607	91.31%
A134	354690	92.17%
A135	316856	92.94%
A136	307724	93.68%
A137	302328	94.42%
A138	279582	95.09%
A139	243310	95.68%
A140	240308	96.27%
A141	227390	96.82%
A142	213176	97.34%
A143	182942	97.78%
A144	160300	98.17%
A145	152614	98.54%
A146	124352	98.84%
A147	116207	99.12%
A148	106588	99.38%
A149	104974	99.63%
A150	93668	99.86%
A151	48448	99.98%
A152	8721	100.00%

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...