topic Re: Total measure need a sum, not calculated in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Total-measure-need-a-sum-not-calculated/m-p/2821518#M89581 <P>Thanks for this<span class="lia-unicode-emoji" title=":thumbs_up:">👍</span> I have now created af measure for every column, and a measure to sum it. That's work</P> Thu, 06 Oct 2022 03:54:02 GMT andreasalleslev 2022-10-06T03:54:02Z Total measure need a sum, not calculated https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Total-measure-need-a-sum-not-calculated/m-p/2818056#M89435 <P>Halo anybody</P><P>&nbsp;</P><P>I have af problem with a the Total on af measure - I hope some day Powerbi come with af button to select wha way the total have to be calculatede. but for now i hope somone can help me.</P><P>&nbsp;</P><P><img /></P><P>The red have to be a sum of row og collunms - not 88021 * 50,25</P><P>&nbsp;</P><P>The meausre is simple: just miltiple 2 measures.</P><P>&nbsp;</P><P>Here is the measures:</P><P>&nbsp;</P><P>1 measure:</P><DIV><DIV><SPAN>beregnet antal på pladsen = </SPAN><SPAN>[Hvad hvis2]</SPAN><SPAN> * </SPAN><SPAN>[Belastnings %]</SPAN></DIV><DIV>&nbsp;</DIV><DIV>2 measure:</DIV><DIV><DIV><DIV><SPAN>Hvad hvis2 = </SPAN></DIV><BR /><DIV><SPAN>var</SPAN> <SPAN>Memba</SPAN><SPAN> = </SPAN><SPAN>SUMX</SPAN><SPAN>(</SPAN><SPAN>VALUES</SPAN><SPAN>(</SPAN><SPAN>'Armbåndtyper'</SPAN><SPAN>[Armbåndstype]</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>'Armbåndtyper'</SPAN><SPAN>[Armbåndstype]</SPAN><SPAN> = </SPAN><SPAN>"Endags"</SPAN><SPAN>, </SPAN><SPAN>0</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>if</SPAN><SPAN>(</SPAN><SPAN>'Armbåndtyper'</SPAN><SPAN>[Armbåndstype]</SPAN><SPAN> = </SPAN><SPAN>"Partout"</SPAN><SPAN>, </SPAN><SPAN>'Memba (alle)'</SPAN><SPAN>[Værdien Memba (alle)]</SPAN><SPAN>, </SPAN><SPAN>0</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; )</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; )</SPAN></DIV><DIV><SPAN>&nbsp;) + </SPAN><SPAN>[Aktive armbaand]</SPAN></DIV><BR /><DIV><SPAN>var</SPAN> <SPAN>Guest</SPAN><SPAN> = </SPAN><SPAN>SUMX</SPAN><SPAN>(</SPAN><SPAN>VALUES</SPAN><SPAN>(</SPAN><SPAN>'Armbåndtyper'</SPAN><SPAN>[Armbåndstype]</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>'Armbåndtyper'</SPAN><SPAN>[Armbåndstype]</SPAN><SPAN> = </SPAN><SPAN>"Endags"</SPAN><SPAN>, </SPAN><SPAN>'Endags Guest'</SPAN><SPAN>[Værdien Endags Guest]</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>'Armbåndtyper'</SPAN><SPAN>[Armbåndstype]</SPAN><SPAN> = </SPAN><SPAN>"Partout"</SPAN><SPAN>, </SPAN><SPAN>'Partout Guest'</SPAN><SPAN>[Værdien Partout Guest]</SPAN><SPAN>, </SPAN><SPAN>0</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; )</SPAN></DIV><DIV><SPAN>) + </SPAN><SPAN>[Aktive armbaand]</SPAN><SPAN> &nbsp; &nbsp; &nbsp; &nbsp;</SPAN></DIV><BR /><DIV><SPAN>var</SPAN> <SPAN>Shop</SPAN><SPAN> = </SPAN><SPAN>SUMX</SPAN><SPAN>(</SPAN><SPAN>VALUES</SPAN><SPAN>(</SPAN><SPAN>'Armbåndtyper'</SPAN><SPAN>[Armbåndstype]</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>'Armbåndtyper'</SPAN><SPAN>[Armbåndstype]</SPAN><SPAN> = </SPAN><SPAN>"Endags"</SPAN><SPAN>, </SPAN><SPAN>'Endags Shop'</SPAN><SPAN>[Værdien Endags Shop]</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>'Armbåndtyper'</SPAN><SPAN>[Armbåndstype]</SPAN><SPAN> = </SPAN><SPAN>"Partout"</SPAN><SPAN>, </SPAN><SPAN>'Partout Shop'</SPAN><SPAN>[Værdien Partout Shop]</SPAN><SPAN>, </SPAN><SPAN>0</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; )</SPAN></DIV><DIV><SPAN>) + </SPAN><SPAN>[Aktive armbaand]</SPAN></DIV><BR /><DIV><SPAN>&nbsp;</SPAN><SPAN>var</SPAN> <SPAN>endags</SPAN><SPAN> = </SPAN><SPAN>'Endags Shop'</SPAN><SPAN>[Værdien Endags Shop]</SPAN><SPAN> + </SPAN><SPAN>'Endags Guest'</SPAN><SPAN>[Værdien Endags Guest]</SPAN><SPAN> + </SPAN><SPAN>[Aktive armbaand]</SPAN></DIV><BR /><DIV><SPAN>&nbsp;</SPAN><SPAN>var</SPAN> <SPAN>partout</SPAN><SPAN> = </SPAN><SPAN>'Partout Guest'</SPAN><SPAN>[Værdien Partout Guest]</SPAN><SPAN> + </SPAN><SPAN>'Partout Shop'</SPAN><SPAN>[Værdien Partout Shop]</SPAN><SPAN> + </SPAN><SPAN>'Memba (alle)'</SPAN><SPAN>[Værdien Memba (alle)]</SPAN><SPAN> + </SPAN><SPAN>[Aktive armbaand]</SPAN></DIV><BR /><DIV><SPAN>&nbsp;</SPAN><SPAN>return</SPAN> <SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>SELECTEDVALUE</SPAN><SPAN>(</SPAN><SPAN>TICKETS</SPAN><SPAN>[System]</SPAN><SPAN>) = </SPAN><SPAN>"Memba"</SPAN><SPAN>, </SPAN><SPAN>Memba</SPAN><SPAN>, </SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>SELECTEDVALUE</SPAN><SPAN>(</SPAN><SPAN>TICKETS</SPAN><SPAN>[System]</SPAN><SPAN>) = </SPAN><SPAN>"Guest"</SPAN><SPAN>, </SPAN><SPAN>Guest</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>SELECTEDVALUE</SPAN><SPAN>(</SPAN><SPAN>TICKETS</SPAN><SPAN>[System]</SPAN><SPAN>) = </SPAN><SPAN>"Venuemanager"</SPAN><SPAN>, </SPAN><SPAN>Shop</SPAN><SPAN>, </SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>SELECTEDVALUE</SPAN><SPAN>(</SPAN><SPAN>'Armbåndtyper'</SPAN><SPAN>[Armbåndstype]</SPAN><SPAN>) = </SPAN><SPAN>"Endags"</SPAN><SPAN>, </SPAN><SPAN>endags</SPAN><SPAN>, </SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>SELECTEDVALUE</SPAN><SPAN>(</SPAN><SPAN>'Armbåndtyper'</SPAN><SPAN>[Armbåndstype]</SPAN><SPAN>) = </SPAN><SPAN>"Partout"</SPAN><SPAN>, </SPAN><SPAN>partout</SPAN><SPAN>, </SPAN><SPAN>partout</SPAN><SPAN>+</SPAN><SPAN>'Endags Shop'</SPAN><SPAN>[Værdien Endags Shop]</SPAN><SPAN>+</SPAN><SPAN>'Endags Guest'</SPAN><SPAN>[Værdien Endags Guest]</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; )</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; ) </SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>3 measure:</SPAN></DIV><DIV><DIV><DIV><SPAN>Belastnings % = </SPAN><SPAN>DIVIDE</SPAN><SPAN>(</SPAN><SPAN>[Antal på pladsen]</SPAN><SPAN>, </SPAN><SPAN>[Aktive armbaand]</SPAN><SPAN>) </SPAN></DIV></DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp;</SPAN></DIV></DIV></DIV></DIV><P>Hope someone can help me.</P><P>&nbsp;</P><P>Best regards Andreas</P><P>&nbsp;</P> Tue, 04 Oct 2022 21:28:48 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Total-measure-need-a-sum-not-calculated/m-p/2818056#M89435 andreasalleslev 2022-10-04T21:28:48Z Re: Total measure need a sum, not calculated https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Total-measure-need-a-sum-not-calculated/m-p/2818083#M89441 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="185899" data-lia-user-login="andreasalleslev" class="lia-mention lia-mention-user">andreasalleslev</a>&nbsp;Seems like the fourth one of these today at least.</P> <P>First, please vote for this idea: <A href="https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e" target="_blank" rel="noopener">https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e</A></P> <P>&nbsp;</P> <P>This looks like a measure totals problem. Very common. See my post about it here: <A href="https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376" target="_blank" rel="noopener">https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376</A><BR /><BR />Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:<BR /><A href="https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907" target="_blank" rel="noopener">https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907</A></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>Also: <A href="https://youtu.be/uXRriTN0cfY" target="_blank" rel="noopener">https://youtu.be/uXRriTN0cfY</A></P> <P>And: <A href="https://youtu.be/n4TYhF2ARe8" target="_blank" rel="noopener">https://youtu.be/n4TYhF2ARe8</A></P> <P>&nbsp;</P> Tue, 04 Oct 2022 21:45:33 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Total-measure-need-a-sum-not-calculated/m-p/2818083#M89441 Greg_Deckler 2022-10-04T21:45:33Z Re: Total measure need a sum, not calculated https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Total-measure-need-a-sum-not-calculated/m-p/2821518#M89581 <P>Thanks for this<span class="lia-unicode-emoji" title=":thumbs_up:">👍</span> I have now created af measure for every column, and a measure to sum it. That's work</P> Thu, 06 Oct 2022 03:54:02 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Total-measure-need-a-sum-not-calculated/m-p/2821518#M89581 andreasalleslev 2022-10-06T03:54:02Z