Forum Discussion
undefinedDynamic Threshold Setting for Pareto Analysis Using Parameters
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?
2 Replies
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-Forum/ba-p/963216
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/1447523Thank 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%
