topic Re: Use Case and Switch instead of IFs in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Use-Case-and-Switch-instead-of-IFs/m-p/4245991#M168099 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="409157" data-lia-user-login="AGaribay7" class="lia-mention lia-mention-user">AGaribay7</a>&nbsp; Try</P><PRE>SEASON TOTAL = <BR />SWITCH(<BR />TRUE(),<BR />VALUES(Rankings[Attribute]) = "AERIAL DUELS WON %", FORMAT(SUM(Rankings[Value]),"##%"),<BR />VALUES(Rankings[Attribute]) = "CROSSES", FORMAT(SUM(Rankings[Value]),"##"),<BR />VALUES(Rankings[Attribute]) = "Crossing%", FORMAT(SUM(Rankings[Value]),"##%"),<BR />VALUES(Rankings[Attribute]) = "FORWARD PASSES %", FORMAT(SUM(Rankings[Value]),"##%"),<BR />VALUES(Rankings[Attribute]) = "FOULS COMMITTED", FORMAT(SUM(Rankings[Value]),"##"),<BR />VALUES(Rankings[Attribute]) = "GOALS", FORMAT(SUM(Rankings[Value]),"##"),<BR />VALUES(Rankings[Attribute]) = "GOALS CONCEDED", FORMAT(SUM(Rankings[Value]),"##"),<BR />VALUES(Rankings[Attribute]) = "GROUND DUELS WON %", FORMAT(SUM(Rankings[Value]),"##%"),<BR />VALUES(Rankings[Attribute]) = "NON-PENALTY SHOT CONVERSION RATE %", FORMAT(SUM(Rankings[Value]),"##%"),<BR />VALUES(Rankings[Attribute]) = "NON-PENALTY SHOTS", FORMAT(SUM(Rankings[Value]),"##"),<BR />VALUES(Rankings[Attribute]) = "OWN HALF BALL LOSS", FORMAT(SUM(Rankings[Value]),"##"),<BR />VALUES(Rankings[Attribute]) = "PASS FORWARD IN FINAL 3RD %", FORMAT(SUM(Rankings[Value]),"##%"),<BR />VALUES(Rankings[Attribute]) = "PASSES", FORMAT(SUM(Rankings[Value]),"##"),<BR />VALUES(Rankings[Attribute]) = "POSSESSION REGAINS IN OPPO HALF TOTAL", FORMAT(SUM(Rankings[Value]),"##"),<BR />VALUES(Rankings[Attribute]) = "Possession%", FORMAT(SUM(Rankings[Value]),"##%"),<BR />VALUES(Rankings[Attribute]) = "RED CARDS", IF(SUM(Rankings[Value]) &gt; 0, FORMAT(SUM(Rankings[Value]),"##"), 0),<BR />VALUES(Rankings[Attribute]) = "SHOTS INSIDE BOX", FORMAT(SUM(Rankings[Value]),"##"),<BR />VALUES(Rankings[Attribute]) = "SHOTS ON TARGET %", FORMAT(SUM(Rankings[Value]),"##%"),<BR />VALUES(Rankings[Attribute]) = "SHOTS OUTSIDE BOX", FORMAT(SUM(Rankings[Value]),"##"),<BR />VALUES(Rankings[Attribute]) = "Successful Box Cross", FORMAT(SUM(Rankings[Value]),"##"),<BR />VALUES(Rankings[Attribute]) = "YELLOW CARDS", FORMAT(SUM(Rankings[Value]),"##"),<BR />BLANK() -- Default case if no condition matches<BR />)</PRE><P><U><STRONG><span class="lia-unicode-emoji" title=":love_letter:">💌</span> If this helped, a Kudos <span class="lia-unicode-emoji" title=":thumbs_up:">👍</span> or Solution mark would be great! <span class="lia-unicode-emoji" title=":party_popper:">🎉</span></STRONG></U><BR />Cheers,<BR />Kedar<BR /><A href="https://www.linkedin.com/in/kedar-pande" target="_blank" rel="noopener">Connect on LinkedIn</A></P> Thu, 17 Oct 2024 06:40:32 GMT Kedar_Pande 2024-10-17T06:40:32Z Use Case and Switch instead of IFs https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Use-Case-and-Switch-instead-of-IFs/m-p/4245266#M168080 <P>Hi!&nbsp;<BR /><BR />I would like to know, how can I change this DAX Code ... to use Switch Case instead of IFs<BR /><BR /></P><DIV><DIV><SPAN>SEASON TOTAL =</SPAN> <SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>VALUES</SPAN><SPAN>(</SPAN><SPAN>Rankings</SPAN><SPAN>[Attribute]</SPAN><SPAN>) = </SPAN><SPAN>"AERIAL DUELS WON %"</SPAN><SPAN>, </SPAN><SPAN>format</SPAN><SPAN>(</SPAN><SPAN>SUM</SPAN><SPAN>(</SPAN><SPAN>Rankings</SPAN><SPAN>[Value]</SPAN><SPAN>),</SPAN><SPAN>"##%"</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>VALUES</SPAN><SPAN>(</SPAN><SPAN>Rankings</SPAN><SPAN>[Attribute]</SPAN><SPAN>) = </SPAN><SPAN>"CROSSES"</SPAN><SPAN>,</SPAN><SPAN>FORMAT</SPAN><SPAN>(</SPAN><SPAN>SUM</SPAN><SPAN>(</SPAN><SPAN>Rankings</SPAN><SPAN>[Value]</SPAN><SPAN>),</SPAN><SPAN>"##"</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>VALUES</SPAN><SPAN>(</SPAN><SPAN>Rankings</SPAN><SPAN>[Attribute]</SPAN><SPAN>) = </SPAN><SPAN>"Crossing%"</SPAN><SPAN>,</SPAN><SPAN>FORMAT</SPAN><SPAN>(</SPAN><SPAN>SUM</SPAN><SPAN>(</SPAN><SPAN>Rankings</SPAN><SPAN>[Value]</SPAN><SPAN>),</SPAN><SPAN>"##%"</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>VALUES</SPAN><SPAN>(</SPAN><SPAN>Rankings</SPAN><SPAN>[Attribute]</SPAN><SPAN>) = </SPAN><SPAN>"FORWARD PASSES %"</SPAN><SPAN>,</SPAN><SPAN>FORMAT</SPAN><SPAN>(</SPAN><SPAN>SUM</SPAN><SPAN>(</SPAN><SPAN>Rankings</SPAN><SPAN>[Value]</SPAN><SPAN>),</SPAN><SPAN>"##%"</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>VALUES</SPAN><SPAN>(</SPAN><SPAN>Rankings</SPAN><SPAN>[Attribute]</SPAN><SPAN>) = </SPAN><SPAN>"FOULS COMMITTED"</SPAN><SPAN>,</SPAN><SPAN>FORMAT</SPAN><SPAN>(</SPAN><SPAN>SUM</SPAN><SPAN>(</SPAN><SPAN>Rankings</SPAN><SPAN>[Value]</SPAN><SPAN>),</SPAN><SPAN>"##"</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>VALUES</SPAN><SPAN>(</SPAN><SPAN>Rankings</SPAN><SPAN>[Attribute]</SPAN><SPAN>) = </SPAN><SPAN>"GOALS"</SPAN><SPAN>,</SPAN><SPAN>FORMAT</SPAN><SPAN>(</SPAN><SPAN>SUM</SPAN><SPAN>(</SPAN><SPAN>Rankings</SPAN><SPAN>[Value]</SPAN><SPAN>),</SPAN><SPAN>"##"</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>VALUES</SPAN><SPAN>(</SPAN><SPAN>Rankings</SPAN><SPAN>[Attribute]</SPAN><SPAN>) = </SPAN><SPAN>"GOALS CONCEDED"</SPAN><SPAN>,</SPAN><SPAN>FORMAT</SPAN><SPAN>(</SPAN><SPAN>SUM</SPAN><SPAN>(</SPAN><SPAN>Rankings</SPAN><SPAN>[Value]</SPAN><SPAN>),</SPAN><SPAN>"##"</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>VALUES</SPAN><SPAN>(</SPAN><SPAN>Rankings</SPAN><SPAN>[Attribute]</SPAN><SPAN>) = </SPAN><SPAN>"GROUND DUELS WON %"</SPAN><SPAN>,</SPAN><SPAN>FORMAT</SPAN><SPAN>(</SPAN><SPAN>SUM</SPAN><SPAN>(</SPAN><SPAN>Rankings</SPAN><SPAN>[Value]</SPAN><SPAN>),</SPAN><SPAN>"##%"</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>VALUES</SPAN><SPAN>(</SPAN><SPAN>Rankings</SPAN><SPAN>[Attribute]</SPAN><SPAN>) = </SPAN><SPAN>"NON-PENALTY SHOT CONVERSION RATE %"</SPAN><SPAN>,</SPAN><SPAN>FORMAT</SPAN><SPAN>(</SPAN><SPAN>SUM</SPAN><SPAN>(</SPAN><SPAN>Rankings</SPAN><SPAN>[Value]</SPAN><SPAN>),</SPAN><SPAN>"##%"</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>VALUES</SPAN><SPAN>(</SPAN><SPAN>Rankings</SPAN><SPAN>[Attribute]</SPAN><SPAN>) = </SPAN><SPAN>"NON-PENALTY SHOTS"</SPAN><SPAN>,</SPAN><SPAN>FORMAT</SPAN><SPAN>(</SPAN><SPAN>SUM</SPAN><SPAN>(</SPAN><SPAN>Rankings</SPAN><SPAN>[Value]</SPAN><SPAN>),</SPAN><SPAN>"##"</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>VALUES</SPAN><SPAN>(</SPAN><SPAN>Rankings</SPAN><SPAN>[Attribute]</SPAN><SPAN>) = </SPAN><SPAN>"OWN HALF BALL LOSS"</SPAN><SPAN>,</SPAN><SPAN>FORMAT</SPAN><SPAN>(</SPAN><SPAN>SUM</SPAN><SPAN>(</SPAN><SPAN>Rankings</SPAN><SPAN>[Value]</SPAN><SPAN>),</SPAN><SPAN>"##"</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>VALUES</SPAN><SPAN>(</SPAN><SPAN>Rankings</SPAN><SPAN>[Attribute]</SPAN><SPAN>) = </SPAN><SPAN>"PASS FORWARD IN FINAL 3RD %"</SPAN><SPAN>,</SPAN><SPAN>FORMAT</SPAN><SPAN>(</SPAN><SPAN>SUM</SPAN><SPAN>(</SPAN><SPAN>Rankings</SPAN><SPAN>[Value]</SPAN><SPAN>),</SPAN><SPAN>"##%"</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>VALUES</SPAN><SPAN>(</SPAN><SPAN>Rankings</SPAN><SPAN>[Attribute]</SPAN><SPAN>) = </SPAN><SPAN>"PASSES"</SPAN><SPAN>,</SPAN><SPAN>FORMAT</SPAN><SPAN>(</SPAN><SPAN>SUM</SPAN><SPAN>(</SPAN><SPAN>Rankings</SPAN><SPAN>[Value]</SPAN><SPAN>),</SPAN><SPAN>"##"</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>VALUES</SPAN><SPAN>(</SPAN><SPAN>Rankings</SPAN><SPAN>[Attribute]</SPAN><SPAN>) = </SPAN><SPAN>"POSSESSION REGAINS IN OPPO HALF TOTAL"</SPAN><SPAN>,</SPAN><SPAN>FORMAT</SPAN><SPAN>(</SPAN><SPAN>SUM</SPAN><SPAN>(</SPAN><SPAN>Rankings</SPAN><SPAN>[Value]</SPAN><SPAN>),</SPAN><SPAN>"##"</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>VALUES</SPAN><SPAN>(</SPAN><SPAN>Rankings</SPAN><SPAN>[Attribute]</SPAN><SPAN>) = </SPAN><SPAN>"Possession%"</SPAN><SPAN>,</SPAN><SPAN>FORMAT</SPAN><SPAN>(</SPAN><SPAN>SUM</SPAN><SPAN>(</SPAN><SPAN>Rankings</SPAN><SPAN>[Value]</SPAN><SPAN>),</SPAN><SPAN>"##%"</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>VALUES</SPAN><SPAN>(</SPAN><SPAN>Rankings</SPAN><SPAN>[Attribute]</SPAN><SPAN>) = </SPAN><SPAN>"RED CARDS"</SPAN><SPAN>,</SPAN><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>SUM</SPAN><SPAN>(</SPAN><SPAN>Rankings</SPAN><SPAN>[Value]</SPAN><SPAN>) &gt;</SPAN><SPAN>0</SPAN><SPAN>, </SPAN><SPAN>FORMAT</SPAN><SPAN>(</SPAN><SPAN>SUM</SPAN><SPAN>(</SPAN><SPAN>Rankings</SPAN><SPAN>[Value]</SPAN><SPAN>),</SPAN><SPAN>"##"</SPAN><SPAN>),</SPAN><SPAN>0</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>VALUES</SPAN><SPAN>(</SPAN><SPAN>Rankings</SPAN><SPAN>[Attribute]</SPAN><SPAN>) = </SPAN><SPAN>"SHOTS INSIDE BOX"</SPAN><SPAN>,</SPAN><SPAN>FORMAT</SPAN><SPAN>(</SPAN><SPAN>SUM</SPAN><SPAN>(</SPAN><SPAN>Rankings</SPAN><SPAN>[Value]</SPAN><SPAN>),</SPAN><SPAN>"##"</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>VALUES</SPAN><SPAN>(</SPAN><SPAN>Rankings</SPAN><SPAN>[Attribute]</SPAN><SPAN>) = </SPAN><SPAN>"SHOTS ON TARGET %"</SPAN><SPAN>,</SPAN><SPAN>FORMAT</SPAN><SPAN>(</SPAN><SPAN>SUM</SPAN><SPAN>(</SPAN><SPAN>Rankings</SPAN><SPAN>[Value]</SPAN><SPAN>),</SPAN><SPAN>"##%"</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>VALUES</SPAN><SPAN>(</SPAN><SPAN>Rankings</SPAN><SPAN>[Attribute]</SPAN><SPAN>) = </SPAN><SPAN>"SHOTS OUTSIDE BOX"</SPAN><SPAN>,</SPAN><SPAN>FORMAT</SPAN><SPAN>(</SPAN><SPAN>SUM</SPAN><SPAN>(</SPAN><SPAN>Rankings</SPAN><SPAN>[Value]</SPAN><SPAN>),</SPAN><SPAN>"##"</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>VALUES</SPAN><SPAN>(</SPAN><SPAN>Rankings</SPAN><SPAN>[Attribute]</SPAN><SPAN>) = </SPAN><SPAN>"Successful Box Cross"</SPAN><SPAN>,</SPAN><SPAN>FORMAT</SPAN><SPAN>(</SPAN><SPAN>SUM</SPAN><SPAN>(</SPAN><SPAN>Rankings</SPAN><SPAN>[Value]</SPAN><SPAN>),</SPAN><SPAN>"##"</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>VALUES</SPAN><SPAN>(</SPAN><SPAN>Rankings</SPAN><SPAN>[Attribute]</SPAN><SPAN>) = </SPAN><SPAN>"YELLOW CARDS"</SPAN><SPAN>,</SPAN><SPAN>FORMAT</SPAN><SPAN>(</SPAN><SPAN>SUM</SPAN><SPAN>(</SPAN><SPAN>Rankings</SPAN><SPAN>[Value]</SPAN><SPAN>),</SPAN><SPAN>"##"</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>)))))))))))))))))))))</SPAN></DIV></DIV> Wed, 16 Oct 2024 17:55:54 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Use-Case-and-Switch-instead-of-IFs/m-p/4245266#M168080 AGaribay7 2024-10-16T17:55:54Z Re: Use Case and Switch instead of IFs https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Use-Case-and-Switch-instead-of-IFs/m-p/4245346#M168082 <P>Note:&nbsp; this will only make the code prettier, there is no performance benefit.</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <LI-CODE lang="markup">SEASON TOTAL = SWITCH(TRUE(), VALUES(Rankings[Attribute]) in { "AERIAL DUELS WON %", "Crossing%", "FORWARD PASSES %", "GROUND DUELS WON %", "NON-PENALTY SHOT CONVERSION RATE %", "Possession%", "SHOTS ON TARGET %"}, format(SUM(Rankings[Value]),"##%"), format(SUM(Rankings[Value]),"##") )</LI-CODE> <P>&nbsp;</P> <P>&nbsp;</P> Wed, 16 Oct 2024 19:31:56 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Use-Case-and-Switch-instead-of-IFs/m-p/4245346#M168082 lbendlin 2024-10-16T19:31:56Z Re: Use Case and Switch instead of IFs https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Use-Case-and-Switch-instead-of-IFs/m-p/4245450#M168087 <P>Hi,&nbsp;</P><P>Try the following code:</P><P>&nbsp;</P><UL><LI>SEASON TOTAL =<BR />VAR Attribute = VALUES(Rankings[Attribute])<BR />VAR TotalValue = SUM(Rankings[Value])<BR />RETURN<BR />SWITCH(<BR />TRUE(),<BR />Attribute = "AERIAL DUELS WON %", FORMAT(TotalValue, "##%"),<BR />Attribute = "CROSSES", FORMAT(TotalValue, "##"),<BR />Attribute = "Crossing%", FORMAT(TotalValue, "##%"),<BR />Attribute = "FORWARD PASSES %", FORMAT(TotalValue, "##%"),<BR />Attribute = "FOULS COMMITTED", FORMAT(TotalValue, "##"),<BR />Attribute = "GOALS", FORMAT(TotalValue, "##"),<BR />Attribute = "GOALS CONCEDED", FORMAT(TotalValue, "##"),<BR />Attribute = "GROUND DUELS WON %", FORMAT(TotalValue, "##%"),<BR />Attribute = "NON-PENALTY SHOT CONVERSION RATE %", FORMAT(TotalValue, "##%"),<BR />Attribute = "NON-PENALTY SHOTS", FORMAT(TotalValue, "##"),<BR />Attribute = "OWN HALF BALL LOSS", FORMAT(TotalValue, "##"),<BR />Attribute = "PASS FORWARD IN FINAL 3RD %", FORMAT(TotalValue, "##%"),<BR />Attribute = "PASSES", FORMAT(TotalValue, "##"),<BR />Attribute = "POSSESSION REGAINS IN OPPO HALF TOTAL", FORMAT(TotalValue, "##"),<BR />Attribute = "Possession%", FORMAT(TotalValue, "##%"),<BR />Attribute = "RED CARDS", IF(TotalValue &gt; 0, FORMAT(TotalValue, "##"), 0),<BR />Attribute = "SHOTS INSIDE BOX", FORMAT(TotalValue, "##"),<BR />Attribute = "SHOTS ON TARGET %", FORMAT(TotalValue, "##%"),<BR />Attribute = "SHOTS OUTSIDE BOX", FORMAT(TotalValue, "##"),<BR />Attribute = "Successful Box Cross", FORMAT(TotalValue, "##"),<BR />Attribute = "YELLOW CARDS", FORMAT(TotalValue, "##"),<BR />BLANK()<BR />)</LI></UL> Wed, 16 Oct 2024 21:31:54 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Use-Case-and-Switch-instead-of-IFs/m-p/4245450#M168087 Bibiano_Geraldo 2024-10-16T21:31:54Z Re: Use Case and Switch instead of IFs https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Use-Case-and-Switch-instead-of-IFs/m-p/4245991#M168099 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="409157" data-lia-user-login="AGaribay7" class="lia-mention lia-mention-user">AGaribay7</a>&nbsp; Try</P><PRE>SEASON TOTAL = <BR />SWITCH(<BR />TRUE(),<BR />VALUES(Rankings[Attribute]) = "AERIAL DUELS WON %", FORMAT(SUM(Rankings[Value]),"##%"),<BR />VALUES(Rankings[Attribute]) = "CROSSES", FORMAT(SUM(Rankings[Value]),"##"),<BR />VALUES(Rankings[Attribute]) = "Crossing%", FORMAT(SUM(Rankings[Value]),"##%"),<BR />VALUES(Rankings[Attribute]) = "FORWARD PASSES %", FORMAT(SUM(Rankings[Value]),"##%"),<BR />VALUES(Rankings[Attribute]) = "FOULS COMMITTED", FORMAT(SUM(Rankings[Value]),"##"),<BR />VALUES(Rankings[Attribute]) = "GOALS", FORMAT(SUM(Rankings[Value]),"##"),<BR />VALUES(Rankings[Attribute]) = "GOALS CONCEDED", FORMAT(SUM(Rankings[Value]),"##"),<BR />VALUES(Rankings[Attribute]) = "GROUND DUELS WON %", FORMAT(SUM(Rankings[Value]),"##%"),<BR />VALUES(Rankings[Attribute]) = "NON-PENALTY SHOT CONVERSION RATE %", FORMAT(SUM(Rankings[Value]),"##%"),<BR />VALUES(Rankings[Attribute]) = "NON-PENALTY SHOTS", FORMAT(SUM(Rankings[Value]),"##"),<BR />VALUES(Rankings[Attribute]) = "OWN HALF BALL LOSS", FORMAT(SUM(Rankings[Value]),"##"),<BR />VALUES(Rankings[Attribute]) = "PASS FORWARD IN FINAL 3RD %", FORMAT(SUM(Rankings[Value]),"##%"),<BR />VALUES(Rankings[Attribute]) = "PASSES", FORMAT(SUM(Rankings[Value]),"##"),<BR />VALUES(Rankings[Attribute]) = "POSSESSION REGAINS IN OPPO HALF TOTAL", FORMAT(SUM(Rankings[Value]),"##"),<BR />VALUES(Rankings[Attribute]) = "Possession%", FORMAT(SUM(Rankings[Value]),"##%"),<BR />VALUES(Rankings[Attribute]) = "RED CARDS", IF(SUM(Rankings[Value]) &gt; 0, FORMAT(SUM(Rankings[Value]),"##"), 0),<BR />VALUES(Rankings[Attribute]) = "SHOTS INSIDE BOX", FORMAT(SUM(Rankings[Value]),"##"),<BR />VALUES(Rankings[Attribute]) = "SHOTS ON TARGET %", FORMAT(SUM(Rankings[Value]),"##%"),<BR />VALUES(Rankings[Attribute]) = "SHOTS OUTSIDE BOX", FORMAT(SUM(Rankings[Value]),"##"),<BR />VALUES(Rankings[Attribute]) = "Successful Box Cross", FORMAT(SUM(Rankings[Value]),"##"),<BR />VALUES(Rankings[Attribute]) = "YELLOW CARDS", FORMAT(SUM(Rankings[Value]),"##"),<BR />BLANK() -- Default case if no condition matches<BR />)</PRE><P><U><STRONG><span class="lia-unicode-emoji" title=":love_letter:">💌</span> If this helped, a Kudos <span class="lia-unicode-emoji" title=":thumbs_up:">👍</span> or Solution mark would be great! <span class="lia-unicode-emoji" title=":party_popper:">🎉</span></STRONG></U><BR />Cheers,<BR />Kedar<BR /><A href="https://www.linkedin.com/in/kedar-pande" target="_blank" rel="noopener">Connect on LinkedIn</A></P> Thu, 17 Oct 2024 06:40:32 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Use-Case-and-Switch-instead-of-IFs/m-p/4245991#M168099 Kedar_Pande 2024-10-17T06:40:32Z