topic Re: undefinedDynamic Threshold Setting for Pareto Analysis Using Parameters in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/undefinedDynamic-Threshold-Setting-for-Pareto-Analysis-Using/m-p/4013938#M158101 <P>Please provide sample data that covers your issue or question <STRONG>completely</STRONG>, in a <STRONG>usable</STRONG> format (not as a screenshot).<BR /><BR />Do not include sensitive information or anything not related to the issue or question. <BR /><BR />If you are unsure how to upload data please refer to <A href="https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216" target="_blank">https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216</A> <BR /><BR />Please show the expected outcome based on the sample data you provided. <BR /><BR />Want faster answers? <A href="https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523" target="_blank">https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523</A></P> Thu, 27 Jun 2024 17:08:02 GMT lbendlin 2024-06-27T17:08:02Z undefinedDynamic Threshold Setting for Pareto Analysis Using Parameters https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/undefinedDynamic-Threshold-Setting-for-Pareto-Analysis-Using/m-p/4012935#M158089 <P>I am creating a Pareto chart in Power BI. I have created a new column using the following DAX expressions:</P><P>&nbsp;</P><PRE>Pareto = <BR />VAR ranking = RANKX('Sheet1','Sheet1'[Sales by Product])<BR />VAR runningsum = SUMX(TOPN(ranking,'Sheet1','Sheet1'[Sales by Product],DESC),'Sheet1'[Sales by Product])<BR />VAR total = CALCULATE(SUM('Sheet1'[Sales by Product]),ALL('Sheet1'))<BR />RETURN DIVIDE(runningsum,total)<BR /><BR />ABC Rank = <BR />IF('Sheet1'[Pareto] &lt;= 0.8,"A",<BR />IF('Sheet1'[Pareto] &lt;= 0.9,"B","C"))</PRE><P>&nbsp;</P><P>Next, I want to adjust the thresholds for ABC Rank using parameters so that they can be dynamically adjusted.</P><P>However, I am having trouble getting this to work properly using the new parameter feature in the Modeling tab.</P><P>How can I achieve this?</P> Thu, 27 Jun 2024 08:13:54 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/undefinedDynamic-Threshold-Setting-for-Pareto-Analysis-Using/m-p/4012935#M158089 sugar_sugar 2024-06-27T08:13:54Z Re: undefinedDynamic Threshold Setting for Pareto Analysis Using Parameters https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/undefinedDynamic-Threshold-Setting-for-Pareto-Analysis-Using/m-p/4013938#M158101 <P>Please provide sample data that covers your issue or question <STRONG>completely</STRONG>, in a <STRONG>usable</STRONG> format (not as a screenshot).<BR /><BR />Do not include sensitive information or anything not related to the issue or question. <BR /><BR />If you are unsure how to upload data please refer to <A href="https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216" target="_blank">https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216</A> <BR /><BR />Please show the expected outcome based on the sample data you provided. <BR /><BR />Want faster answers? <A href="https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523" target="_blank">https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523</A></P> Thu, 27 Jun 2024 17:08:02 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/undefinedDynamic-Threshold-Setting-for-Pareto-Analysis-Using/m-p/4013938#M158101 lbendlin 2024-06-27T17:08:02Z Re: undefinedDynamic Threshold Setting for Pareto Analysis Using Parameters https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/undefinedDynamic-Threshold-Setting-for-Pareto-Analysis-Using/m-p/4017843#M158440 <P>Thank you for your response.<BR />I have attached the sample data I am using.<BR />Best regards.</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD><TABLE border="1" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Product ID</TD><TD>Sales by Product</TD><TD>Pareto</TD></TR><TR><TD>A101</TD><TD>4315367</TD><TD>10.47%</TD></TR><TR><TD>A102</TD><TD>4017203</TD><TD>20.21%</TD></TR><TR><TD>A103</TD><TD>2728250</TD><TD>26.82%</TD></TR><TR><TD>A104</TD><TD>2393032</TD><TD>32.63%</TD></TR><TR><TD>A105</TD><TD>2025170</TD><TD>37.54%</TD></TR><TR><TD>A106</TD><TD>1939256</TD><TD>42.24%</TD></TR><TR><TD>A107</TD><TD>1684559</TD><TD>46.33%</TD></TR><TR><TD>A108</TD><TD>1376930</TD><TD>49.67%</TD></TR><TR><TD>A109</TD><TD>1344102</TD><TD>52.92%</TD></TR><TR><TD>A110</TD><TD>1296414</TD><TD>56.07%</TD></TR><TR><TD>A111</TD><TD>1141396</TD><TD>58.84%</TD></TR><TR><TD>A112</TD><TD>1034513</TD><TD>61.35%</TD></TR><TR><TD>A113</TD><TD>949620</TD><TD>63.65%</TD></TR><TR><TD>A114</TD><TD>895013</TD><TD>65.82%</TD></TR><TR><TD>A115</TD><TD>890820</TD><TD>67.98%</TD></TR><TR><TD>A116</TD><TD>736324</TD><TD>69.76%</TD></TR><TR><TD>A117</TD><TD>693144</TD><TD>71.45%</TD></TR><TR><TD>A118</TD><TD>666267</TD><TD>73.06%</TD></TR><TR><TD>A119</TD><TD>659629</TD><TD>74.66%</TD></TR><TR><TD>A120</TD><TD>659563</TD><TD>76.26%</TD></TR><TR><TD>A121</TD><TD>609166</TD><TD>77.74%</TD></TR><TR><TD>A122</TD><TD>587860</TD><TD>79.16%</TD></TR><TR><TD>A123</TD><TD>549414</TD><TD>80.50%</TD></TR><TR><TD>A124</TD><TD>534259</TD><TD>81.79%</TD></TR><TR><TD>A125</TD><TD>522458</TD><TD>83.06%</TD></TR><TR><TD>A126</TD><TD>471520</TD><TD>84.20%</TD></TR><TR><TD>A127</TD><TD>456031</TD><TD>85.31%</TD></TR><TR><TD>A128</TD><TD>440890</TD><TD>86.38%</TD></TR><TR><TD>A129</TD><TD>434803</TD><TD>87.43%</TD></TR><TR><TD>A130</TD><TD>423081</TD><TD>88.46%</TD></TR><TR><TD>A131</TD><TD>417105</TD><TD>89.47%</TD></TR><TR><TD>A132</TD><TD>386868</TD><TD>90.41%</TD></TR><TR><TD>A133</TD><TD>371607</TD><TD>91.31%</TD></TR><TR><TD>A134</TD><TD>354690</TD><TD>92.17%</TD></TR><TR><TD>A135</TD><TD>316856</TD><TD>92.94%</TD></TR><TR><TD>A136</TD><TD>307724</TD><TD>93.68%</TD></TR><TR><TD>A137</TD><TD>302328</TD><TD>94.42%</TD></TR><TR><TD>A138</TD><TD>279582</TD><TD>95.09%</TD></TR><TR><TD>A139</TD><TD>243310</TD><TD>95.68%</TD></TR><TR><TD>A140</TD><TD>240308</TD><TD>96.27%</TD></TR><TR><TD>A141</TD><TD>227390</TD><TD>96.82%</TD></TR><TR><TD>A142</TD><TD>213176</TD><TD>97.34%</TD></TR><TR><TD>A143</TD><TD>182942</TD><TD>97.78%</TD></TR><TR><TD>A144</TD><TD>160300</TD><TD>98.17%</TD></TR><TR><TD>A145</TD><TD>152614</TD><TD>98.54%</TD></TR><TR><TD>A146</TD><TD>124352</TD><TD>98.84%</TD></TR><TR><TD>A147</TD><TD>116207</TD><TD>99.12%</TD></TR><TR><TD>A148</TD><TD>106588</TD><TD>99.38%</TD></TR><TR><TD>A149</TD><TD>104974</TD><TD>99.63%</TD></TR><TR><TD>A150</TD><TD>93668</TD><TD>99.86%</TD></TR><TR><TD>A151</TD><TD>48448</TD><TD>99.98%</TD></TR><TR><TD>A152</TD><TD>8721</TD><TD>100.00%</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE> Mon, 01 Jul 2024 06:15:05 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/undefinedDynamic-Threshold-Setting-for-Pareto-Analysis-Using/m-p/4017843#M158440 sugar_sugar 2024-07-01T06:15:05Z