topic Sum with calculate in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-with-calculate/m-p/892158#M7900 <P>Hola</P><P>&nbsp;</P><P>Estoy usando medidas calculadas en power bi y obtenido la siguiente tabla:</P><DIV><DIV><SPAN>CHR - KM*SCORE = [SUMA KM (CHR)]*[CHR - SCORE (SIN PONDERACION)]</SPAN></DIV></DIV><DIV><DIV><SPAN>SUMA KM (CHR) = CALCULATE(SUM('RANKING FACTOR CONDUCCION SEGURA (SOLO CHR)'[KM TOTAL]))</SPAN></DIV><DIV>&nbsp;</DIV><DIV><DIV><DIV><SPAN>EV - KM*SCORE = [SUMA KM (EV)]*[EV - SCORE (SIN PONDERACION)]</SPAN></DIV></DIV></DIV><DIV><DIV><DIV><SPAN>SUMA KM (EV) = CALCULATE(SUM('RANKING FACTOR CONDUCCION SEGURA (SOLO EV)'[KM TOTAL]))</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>....</SPAN></DIV><DIV>&nbsp;</DIV></DIV></DIV></DIV><TABLE><TBODY><TR><TD>ZONA</TD><TD>OL</TD><TD>KM</TD><TD>CHR - KM*SCORE</TD><TD>03 HR - KM*SCORE</TD><TD>EV - KM*SCORE</TD><TD>MP - KM*SCORE</TD><TD>10 HR - SCORE*KM</TD><TD>DNA - SCORE*KM</TD></TR><TR><TD>BAMBAS</TD><TD>44</TD><TD>9407.74</TD><TD>465714.5695</TD><TD>777208.0639</TD><TD>0</TD><TD>0</TD><TD>843557.844</TD><TD>0</TD></TR><TR><TD>BAMBAS</TD><TD>45</TD><TD>21235.75</TD><TD>812160.363</TD><TD>1102506.272</TD><TD>0</TD><TD>0</TD><TD>1922655.156</TD><TD>0</TD></TR><TR><TD>SUR</TD><TD>50</TD><TD>6027.97</TD><TD>0</TD><TD>437910.3065</TD><TD>0</TD><TD>602797</TD><TD>602797</TD><TD>554787.0496</TD></TR><TR><TD>NORTE</TD><TD>62</TD><TD>5371.02</TD><TD>0</TD><TD>398533.4222</TD><TD>0</TD><TD>537102</TD><TD>364729.0936</TD><TD>449098.5944</TD></TR><TR><TD>BAMBAS</TD><TD>68</TD><TD>1212.47</TD><TD>66948.56283</TD><TD>72247.79203</TD><TD>1257.3</TD><TD>121247</TD><TD>121247</TD><TD>105246.9268</TD></TR><TR><TD>SUR</TD><TD>68</TD><TD>15155.52</TD><TD>0</TD><TD>1061439.397</TD><TD>0</TD><TD>1515552</TD><TD>1515552</TD><TD>0</TD></TR><TR><TD>SUR</TD><TD>70</TD><TD>3796.23</TD><TD>11673.15467</TD><TD>329007.5308</TD><TD>379623</TD><TD>379623</TD><TD>379623</TD><TD>379623</TD></TR><TR><TD>ANTAMINA</TD><TD>116</TD><TD>19104.73</TD><TD>0</TD><TD>1910473</TD><TD>0</TD><TD>1910473</TD><TD>1910473</TD><TD>1686459.603</TD></TR><TR><TD>LIMA</TD><TD>116</TD><TD>8722.61</TD><TD>872261</TD><TD>&nbsp;</TD><TD>0</TD><TD>872261</TD><TD>872261</TD><TD>824244.1688</TD></TR><TR><TD>NORTE</TD><TD>116</TD><TD>8507.17</TD><TD>0</TD><TD>249841.3357</TD><TD>0</TD><TD>850717</TD><TD>735620.6097</TD><TD>698742.936</TD></TR><TR><TD>TOROMOCHO</TD><TD>116</TD><TD>383.71</TD><TD>38371</TD><TD>&nbsp;</TD><TD>0</TD><TD>38371</TD><TD>38371</TD><TD>38371</TD></TR><TR><TD>BAMBAS</TD><TD>117</TD><TD>13162.96</TD><TD>488478.4886</TD><TD>1082553.935</TD><TD>0</TD><TD>0</TD><TD>1299331.767</TD><TD>1004306.146</TD></TR><TR><TD>SUR</TD><TD>117</TD><TD>965.77</TD><TD>0</TD><TD>96577</TD><TD>0</TD><TD>96577</TD><TD>96577</TD><TD>0</TD></TR><TR><TD>CENTRO</TD><TD>120</TD><TD>3413.87</TD><TD>341387</TD><TD>341387</TD><TD>0</TD><TD>341387</TD><TD>334380.5693</TD><TD>277393.972</TD></TR><TR><TD>NORTE</TD><TD>120</TD><TD>47.46</TD><TD>0</TD><TD>4746</TD><TD>4746</TD><TD>4746</TD><TD>4746</TD><TD>0</TD></TR><TR><TD>SUR</TD><TD>120</TD><TD>1023.58</TD><TD>0</TD><TD>69326.12161</TD><TD>0</TD><TD>102358</TD><TD>102358</TD><TD>14368.616</TD></TR><TR><TD>BAMBAS</TD><TD>121</TD><TD>5013.16</TD><TD>139306.2213</TD><TD>251369.1268</TD><TD>201226.98</TD><TD>501316</TD><TD>501316</TD><TD>0</TD></TR><TR><TD>CENTRO</TD><TD>121</TD><TD>3443.05</TD><TD>0</TD><TD>252088.5106</TD><TD>0</TD><TD>344305</TD><TD>264944.1495</TD><TD>176323.7544</TD></TR><TR><TD>LIMA</TD><TD>121</TD><TD>1507.96</TD><TD>150796</TD><TD>&nbsp;</TD><TD>0</TD><TD>150796</TD><TD>150796</TD><TD>150796</TD></TR><TR><TD>NACIONAL</TD><TD>121</TD><TD>12423.43</TD><TD>1182049.21</TD><TD>1242343</TD><TD>1212502.36</TD><TD>1242343</TD><TD>1242343</TD><TD>1178336.614</TD></TR><TR><TD>CENTRO</TD><TD>122</TD><TD>8478.71</TD><TD>0</TD><TD>423999.487</TD><TD>0</TD><TD>847871</TD><TD>847871</TD><TD>647894.1164</TD></TR><TR><TD>NORTE</TD><TD>122</TD><TD>9</TD><TD>438.3</TD><TD>900</TD><TD>900</TD><TD>900</TD><TD>900</TD><TD>900</TD></TR><TR><TD>BAMBAS</TD><TD>124</TD><TD>1953.45</TD><TD>97272.84858</TD><TD>195345</TD><TD>0</TD><TD>195345</TD><TD>195345</TD><TD>0</TD></TR><TR><TD>NACIONAL</TD><TD>124</TD><TD>5424.71</TD><TD>75358.73802</TD><TD>394064.2089</TD><TD>0</TD><TD>542471</TD><TD>433841.5923</TD><TD>222510.2856</TD></TR><TR><TD>SUR</TD><TD>124</TD><TD>1253.48</TD><TD>24393.13126</TD><TD>79627.47751</TD><TD>0</TD><TD>125348</TD><TD>125348</TD><TD>53358.8156</TD></TR><TR><TD>SUR</TD><TD>135</TD><TD>19155.5</TD><TD>0</TD><TD>1579324.272</TD><TD>0</TD><TD>1915550</TD><TD>1619027.227</TD><TD>1507550.367</TD></TR><TR><TD>BAMBAS</TD><TD>145</TD><TD>1883.54</TD><TD>0</TD><TD>188354</TD><TD>0</TD><TD>188354</TD><TD>188354</TD><TD>132350.256</TD></TR><TR><TD>NORTE</TD><TD>163</TD><TD>3865.97</TD><TD>299115.9271</TD><TD>386597</TD><TD>386597</TD><TD>386597</TD><TD>386597</TD><TD>386597</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>QUIERO APLICAR AL SIGUIENTE LOGICA PARA OBTENER LA SIGUIENTE TABLA:</P><P>&nbsp;</P><P>DESEMPEÑO EV= SUMA (EV - KM*SCORE)&nbsp; /&nbsp; SUMA (KM)</P><P>DESEMPEÑO CHR = SUMA (CHR - KM*SCORE)&nbsp; /&nbsp; SUMA (KM)</P><P>DESEMPEÑO MP = SUMA (MP - KM*SCORE)&nbsp; /&nbsp; SUMA (KM)</P><P>...</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>INDIVIDUO</TD><TD>CHR - KM*SCORE</TD><TD>03 HR - KM*SCORE</TD><TD>EV - KM*SCORE</TD><TD>MP - KM*SCORE</TD><TD>10 HR - SCORE*KM</TD><TD>DNA - SCORE*KM</TD></TR><TR><TD>TODAS LAS ZONAS-OL</TD><TD>27.84122032</TD><TD>71.05101574</TD><TD>12.01894141</TD><TD>75.92397647</TD><TD>93.98688725</TD><TD>57.64896534</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P>Saludos.</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 07 Jan 2020 15:21:08 GMT Bladimir 2020-01-07T15:21:08Z Sum with calculate https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-with-calculate/m-p/892158#M7900 <P>Hola</P><P>&nbsp;</P><P>Estoy usando medidas calculadas en power bi y obtenido la siguiente tabla:</P><DIV><DIV><SPAN>CHR - KM*SCORE = [SUMA KM (CHR)]*[CHR - SCORE (SIN PONDERACION)]</SPAN></DIV></DIV><DIV><DIV><SPAN>SUMA KM (CHR) = CALCULATE(SUM('RANKING FACTOR CONDUCCION SEGURA (SOLO CHR)'[KM TOTAL]))</SPAN></DIV><DIV>&nbsp;</DIV><DIV><DIV><DIV><SPAN>EV - KM*SCORE = [SUMA KM (EV)]*[EV - SCORE (SIN PONDERACION)]</SPAN></DIV></DIV></DIV><DIV><DIV><DIV><SPAN>SUMA KM (EV) = CALCULATE(SUM('RANKING FACTOR CONDUCCION SEGURA (SOLO EV)'[KM TOTAL]))</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>....</SPAN></DIV><DIV>&nbsp;</DIV></DIV></DIV></DIV><TABLE><TBODY><TR><TD>ZONA</TD><TD>OL</TD><TD>KM</TD><TD>CHR - KM*SCORE</TD><TD>03 HR - KM*SCORE</TD><TD>EV - KM*SCORE</TD><TD>MP - KM*SCORE</TD><TD>10 HR - SCORE*KM</TD><TD>DNA - SCORE*KM</TD></TR><TR><TD>BAMBAS</TD><TD>44</TD><TD>9407.74</TD><TD>465714.5695</TD><TD>777208.0639</TD><TD>0</TD><TD>0</TD><TD>843557.844</TD><TD>0</TD></TR><TR><TD>BAMBAS</TD><TD>45</TD><TD>21235.75</TD><TD>812160.363</TD><TD>1102506.272</TD><TD>0</TD><TD>0</TD><TD>1922655.156</TD><TD>0</TD></TR><TR><TD>SUR</TD><TD>50</TD><TD>6027.97</TD><TD>0</TD><TD>437910.3065</TD><TD>0</TD><TD>602797</TD><TD>602797</TD><TD>554787.0496</TD></TR><TR><TD>NORTE</TD><TD>62</TD><TD>5371.02</TD><TD>0</TD><TD>398533.4222</TD><TD>0</TD><TD>537102</TD><TD>364729.0936</TD><TD>449098.5944</TD></TR><TR><TD>BAMBAS</TD><TD>68</TD><TD>1212.47</TD><TD>66948.56283</TD><TD>72247.79203</TD><TD>1257.3</TD><TD>121247</TD><TD>121247</TD><TD>105246.9268</TD></TR><TR><TD>SUR</TD><TD>68</TD><TD>15155.52</TD><TD>0</TD><TD>1061439.397</TD><TD>0</TD><TD>1515552</TD><TD>1515552</TD><TD>0</TD></TR><TR><TD>SUR</TD><TD>70</TD><TD>3796.23</TD><TD>11673.15467</TD><TD>329007.5308</TD><TD>379623</TD><TD>379623</TD><TD>379623</TD><TD>379623</TD></TR><TR><TD>ANTAMINA</TD><TD>116</TD><TD>19104.73</TD><TD>0</TD><TD>1910473</TD><TD>0</TD><TD>1910473</TD><TD>1910473</TD><TD>1686459.603</TD></TR><TR><TD>LIMA</TD><TD>116</TD><TD>8722.61</TD><TD>872261</TD><TD>&nbsp;</TD><TD>0</TD><TD>872261</TD><TD>872261</TD><TD>824244.1688</TD></TR><TR><TD>NORTE</TD><TD>116</TD><TD>8507.17</TD><TD>0</TD><TD>249841.3357</TD><TD>0</TD><TD>850717</TD><TD>735620.6097</TD><TD>698742.936</TD></TR><TR><TD>TOROMOCHO</TD><TD>116</TD><TD>383.71</TD><TD>38371</TD><TD>&nbsp;</TD><TD>0</TD><TD>38371</TD><TD>38371</TD><TD>38371</TD></TR><TR><TD>BAMBAS</TD><TD>117</TD><TD>13162.96</TD><TD>488478.4886</TD><TD>1082553.935</TD><TD>0</TD><TD>0</TD><TD>1299331.767</TD><TD>1004306.146</TD></TR><TR><TD>SUR</TD><TD>117</TD><TD>965.77</TD><TD>0</TD><TD>96577</TD><TD>0</TD><TD>96577</TD><TD>96577</TD><TD>0</TD></TR><TR><TD>CENTRO</TD><TD>120</TD><TD>3413.87</TD><TD>341387</TD><TD>341387</TD><TD>0</TD><TD>341387</TD><TD>334380.5693</TD><TD>277393.972</TD></TR><TR><TD>NORTE</TD><TD>120</TD><TD>47.46</TD><TD>0</TD><TD>4746</TD><TD>4746</TD><TD>4746</TD><TD>4746</TD><TD>0</TD></TR><TR><TD>SUR</TD><TD>120</TD><TD>1023.58</TD><TD>0</TD><TD>69326.12161</TD><TD>0</TD><TD>102358</TD><TD>102358</TD><TD>14368.616</TD></TR><TR><TD>BAMBAS</TD><TD>121</TD><TD>5013.16</TD><TD>139306.2213</TD><TD>251369.1268</TD><TD>201226.98</TD><TD>501316</TD><TD>501316</TD><TD>0</TD></TR><TR><TD>CENTRO</TD><TD>121</TD><TD>3443.05</TD><TD>0</TD><TD>252088.5106</TD><TD>0</TD><TD>344305</TD><TD>264944.1495</TD><TD>176323.7544</TD></TR><TR><TD>LIMA</TD><TD>121</TD><TD>1507.96</TD><TD>150796</TD><TD>&nbsp;</TD><TD>0</TD><TD>150796</TD><TD>150796</TD><TD>150796</TD></TR><TR><TD>NACIONAL</TD><TD>121</TD><TD>12423.43</TD><TD>1182049.21</TD><TD>1242343</TD><TD>1212502.36</TD><TD>1242343</TD><TD>1242343</TD><TD>1178336.614</TD></TR><TR><TD>CENTRO</TD><TD>122</TD><TD>8478.71</TD><TD>0</TD><TD>423999.487</TD><TD>0</TD><TD>847871</TD><TD>847871</TD><TD>647894.1164</TD></TR><TR><TD>NORTE</TD><TD>122</TD><TD>9</TD><TD>438.3</TD><TD>900</TD><TD>900</TD><TD>900</TD><TD>900</TD><TD>900</TD></TR><TR><TD>BAMBAS</TD><TD>124</TD><TD>1953.45</TD><TD>97272.84858</TD><TD>195345</TD><TD>0</TD><TD>195345</TD><TD>195345</TD><TD>0</TD></TR><TR><TD>NACIONAL</TD><TD>124</TD><TD>5424.71</TD><TD>75358.73802</TD><TD>394064.2089</TD><TD>0</TD><TD>542471</TD><TD>433841.5923</TD><TD>222510.2856</TD></TR><TR><TD>SUR</TD><TD>124</TD><TD>1253.48</TD><TD>24393.13126</TD><TD>79627.47751</TD><TD>0</TD><TD>125348</TD><TD>125348</TD><TD>53358.8156</TD></TR><TR><TD>SUR</TD><TD>135</TD><TD>19155.5</TD><TD>0</TD><TD>1579324.272</TD><TD>0</TD><TD>1915550</TD><TD>1619027.227</TD><TD>1507550.367</TD></TR><TR><TD>BAMBAS</TD><TD>145</TD><TD>1883.54</TD><TD>0</TD><TD>188354</TD><TD>0</TD><TD>188354</TD><TD>188354</TD><TD>132350.256</TD></TR><TR><TD>NORTE</TD><TD>163</TD><TD>3865.97</TD><TD>299115.9271</TD><TD>386597</TD><TD>386597</TD><TD>386597</TD><TD>386597</TD><TD>386597</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>QUIERO APLICAR AL SIGUIENTE LOGICA PARA OBTENER LA SIGUIENTE TABLA:</P><P>&nbsp;</P><P>DESEMPEÑO EV= SUMA (EV - KM*SCORE)&nbsp; /&nbsp; SUMA (KM)</P><P>DESEMPEÑO CHR = SUMA (CHR - KM*SCORE)&nbsp; /&nbsp; SUMA (KM)</P><P>DESEMPEÑO MP = SUMA (MP - KM*SCORE)&nbsp; /&nbsp; SUMA (KM)</P><P>...</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>INDIVIDUO</TD><TD>CHR - KM*SCORE</TD><TD>03 HR - KM*SCORE</TD><TD>EV - KM*SCORE</TD><TD>MP - KM*SCORE</TD><TD>10 HR - SCORE*KM</TD><TD>DNA - SCORE*KM</TD></TR><TR><TD>TODAS LAS ZONAS-OL</TD><TD>27.84122032</TD><TD>71.05101574</TD><TD>12.01894141</TD><TD>75.92397647</TD><TD>93.98688725</TD><TD>57.64896534</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P>Saludos.</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 07 Jan 2020 15:21:08 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-with-calculate/m-p/892158#M7900 Bladimir 2020-01-07T15:21:08Z Re: Sum with calculate https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-with-calculate/m-p/897167#M8119 <P>Parece que queire construir una table con un record que contiene sumas para la tabla de ejemplo.</P><P><A href="https://radacad.com/creating-a-table-in-power-bi-using-dax-table-constructor" target="_blank">https://radacad.com/creating-a-table-in-power-bi-using-dax-table-constructor</A></P><P>este articulo descirbe como hacerlo in DAX.&nbsp; Tienia que escribir una medida para cada columna, pero las medidas pueden hacer qualquier calculacion .</P><P>&nbsp;</P><P><A href="https://personalpowerbitrainer.com/" target="_blank">Soy un personal Power Bi Trainer</A><EM>&nbsp; aprendo cada vez que respondo a una pregunta</EM></P><P><EM>The Golden Rules for Power BI</EM></P><OL><LI>Use a Calendar table. A custom Date tables is preferable to using the automatic date/time handling capabilities of Power BI. <A href="https://www.youtube.com/watch?v=FxiAYGbCfAQ" target="_blank">https://www.youtube.com/watch?v=FxiAYGbCfAQ</A></LI><LI>Build your data model as a Star Schema. Creating a star schema in Power BI is the best practice to improve performance and more importantly, to ensure accurate results! <A href="https://www.youtube.com/watch?v=1Kilya6aUQw" target="_blank">https://www.youtube.com/watch?v=1Kilya6aUQw</A></LI><LI>Use a small set up sample data when developing. When building your measures and calculated columns always use a small amount of sample data so that it will be easier to confirm that you are getting the right numbers.</LI><LI>Store all your intermediate calculations in VARs when you’re writing measures. You can return these intermediate VARs instead of your final result &nbsp;to check on your steps along the way.</LI></OL> Sun, 12 Jan 2020 14:31:46 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-with-calculate/m-p/897167#M8119 kentyler 2020-01-12T14:31:46Z