topic I need to supress the rows where the column sub-total has no value. in DAX Commands and Tips

topic I need to supress the rows where the column sub-total has no value. in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/I-need-to-supress-the-rows-where-the-column-sub-total-has-no/m-p/4337661#M172237 <P>The show items with No data works, if I have not formatted the Amounts in my columns, but once I format it using DAX, this option doesn't work anymore.</P><P>This one is w/o formatting the amount column</P><P><img /></P><P> </P><P>This one is after formatting the Amount Columns(Month-Year)</P><P><img /></P><P> </P><P><FONT face="courier new,courier" size="2">My DAX for Visual 2 - What can I add here to suppress rows which have no data in the month columns!</FONT></P><DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>Actuals = </SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>VAR</SPAN><SPAN> _selectedHeader = </SPAN><SPAN>SELECTEDVALUE</SPAN><SPAN> ('a360_finance fin_PnL_Template2'[Level_1])</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>VAR</SPAN><SPAN> _Actuals = </SPAN><SPAN>FORMAT</SPAN><SPAN>([Actual Amount],</SPAN><SPAN>"#,##0.00;(#,##0.00)"</SPAN><SPAN>)</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>VAR</SPAN><SPAN> _IsLevel2Visible = </SPAN><SPAN>ISINSCOPE</SPAN><SPAN>('a360_finance fin_PnL_Template2'[Level_2])</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>VAR</SPAN><SPAN> _DisplayDetailCode = </SPAN><SPAN>SELECTEDVALUE</SPAN><SPAN>('a360_finance fin_PnL_Template2'[Highlight])</SPAN></FONT></DIV><BR /><DIV><FONT face="courier new,courier" size="2"><SPAN>VAR</SPAN><SPAN> _Revenue = </SPAN><SPAN>CALCULATE</SPAN><SPAN>([Actual Amount],</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>                               </SPAN><SPAN>REMOVEFILTERS</SPAN><SPAN>('a360_finance fin_PnL_Template2'),</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>                               'a360_finance fin_PnL_Template2'[Level_1] </SPAN><SPAN>IN</SPAN><SPAN> {</SPAN><SPAN>"Sales Revenue"</SPAN><SPAN>}</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>                               )</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>VAR</SPAN><SPAN> _COGS = </SPAN><SPAN>CALCULATE</SPAN><SPAN>([Actual Amount],</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>                               </SPAN><SPAN>REMOVEFILTERS</SPAN><SPAN>('a360_finance fin_PnL_Template2'),</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>                               'a360_finance fin_PnL_Template2'[Level_1] </SPAN><SPAN>IN</SPAN><SPAN> {</SPAN><SPAN>"Cost of Products Sold"</SPAN><SPAN>}</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>                               )</SPAN></FONT></DIV><BR /><DIV><FONT face="courier new,courier" size="2"><SPAN>VAR</SPAN><SPAN> _CM = </SPAN><SPAN>CALCULATE</SPAN><SPAN>([Actual Amount],</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>                               </SPAN><SPAN>REMOVEFILTERS</SPAN><SPAN>('a360_finance fin_PnL_Template2'),</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>                               'a360_finance fin_PnL_Template2'[Level_1] </SPAN><SPAN>IN</SPAN><SPAN> {</SPAN><SPAN>"Sales Revenue"</SPAN><SPAN>,</SPAN><SPAN>"Cost of Products Sold"</SPAN><SPAN>}</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>                               )</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>VAR</SPAN><SPAN> _OCGS = </SPAN><SPAN>CALCULATE</SPAN><SPAN>([Actual Amount],</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>                               </SPAN><SPAN>REMOVEFILTERS</SPAN><SPAN>('a360_finance fin_PnL_Template2'),</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>                               'a360_finance fin_PnL_Template2'[Level_1] </SPAN><SPAN>IN</SPAN><SPAN> {</SPAN><SPAN>"Other COGS"</SPAN><SPAN>}</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>                               )</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>VAR</SPAN><SPAN> _SGA = </SPAN><SPAN>CALCULATE</SPAN><SPAN>([Actual Amount],</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>                               </SPAN><SPAN>REMOVEFILTERS</SPAN><SPAN>('a360_finance fin_PnL_Template2'),</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>                               'a360_finance fin_PnL_Template2'[Level_1] </SPAN><SPAN>IN</SPAN><SPAN> {</SPAN><SPAN>"SGA"</SPAN><SPAN>}</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>                                )</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>VAR</SPAN><SPAN> _NOPEXP = </SPAN><SPAN>CALCULATE</SPAN><SPAN>([Actual Amount],</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>                               </SPAN><SPAN>REMOVEFILTERS</SPAN><SPAN>('a360_finance fin_PnL_Template2'),</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>                               'a360_finance fin_PnL_Template2'[Level_1] </SPAN><SPAN>IN</SPAN><SPAN> {</SPAN><SPAN>"Non Operating"</SPAN><SPAN>}</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>                                )</SPAN></FONT></DIV><BR /><BR /><BR /><DIV><FONT face="courier new,courier" size="2"><SPAN>VAR</SPAN><SPAN> _Results = </SPAN><SPAN>SWITCH</SPAN><SPAN>(</SPAN><SPAN>TRUE</SPAN><SPAN>(),</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>_IsLevel2Visible = </SPAN><SPAN>TRUE</SPAN><SPAN>() && _DisplayDetailCode = </SPAN><SPAN>1</SPAN><SPAN>, </SPAN><SPAN>Blank</SPAN><SPAN>(),</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>_selectedHeader = </SPAN><SPAN>"Revenue"</SPAN><SPAN>, </SPAN><SPAN>FORMAT</SPAN><SPAN>(_Revenue, </SPAN><SPAN>"#,##0.00;(#,##0.00)"</SPAN><SPAN>),</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>_selectedHeader = </SPAN><SPAN>"Cost of  Goods Sold"</SPAN><SPAN>, </SPAN><SPAN>FORMAT</SPAN><SPAN>(_COGS,</SPAN><SPAN>"#,##0.00;(#,##0.00)"</SPAN><SPAN>),</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>_selectedHeader = </SPAN><SPAN>"Contribution Margin"</SPAN><SPAN>,  </SPAN><SPAN>FORMAT</SPAN><SPAN>(_CM,</SPAN><SPAN>"#,##0.00;(#,##0.00)"</SPAN><SPAN>),</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>_selectedHeader = </SPAN><SPAN>"Contribution Margin Percentage"</SPAN><SPAN>, </SPAN><SPAN>FORMAT</SPAN><SPAN>((_CM/_Revenue), </SPAN><SPAN>"#0.0%;(#0.0%)"</SPAN><SPAN>),</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>_selectedHeader = </SPAN><SPAN>"Other Cost of Goods Sold"</SPAN><SPAN>, </SPAN><SPAN>FORMAT</SPAN><SPAN>(_OCGS,</SPAN><SPAN>"#,##0.00;(#,##0.00)"</SPAN><SPAN>),</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>_selectedHeader = </SPAN><SPAN>"Total COGS"</SPAN><SPAN>, </SPAN><SPAN>FORMAT</SPAN><SPAN>(_COGS+_OCGS,</SPAN><SPAN>"#,##0.00;(#,##0.00)"</SPAN><SPAN>),</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>_selectedHeader = </SPAN><SPAN>"Gross Profit"</SPAN><SPAN>, </SPAN><SPAN>FORMAT</SPAN><SPAN>(_Revenue+_COGS+_OCGS,</SPAN><SPAN>"#,##0.00;(#,##0.00)"</SPAN><SPAN>),</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>_selectedHeader = </SPAN><SPAN>"Gross Profit Percentage"</SPAN><SPAN>, </SPAN><SPAN>FORMAT</SPAN><SPAN>((_Revenue+_COGS+_OCGS)/_Revenue,</SPAN><SPAN>"#0.0%;(#0.0%)"</SPAN><SPAN>),</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>_selectedHeader = </SPAN><SPAN>"Total SGA"</SPAN><SPAN>, </SPAN><SPAN>FORMAT</SPAN><SPAN>(_SGA,</SPAN><SPAN>"#,##0.00;(#,##0.00)"</SPAN><SPAN>),</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>_selectedHeader = </SPAN><SPAN>"Total Operating Expenses"</SPAN><SPAN>, </SPAN><SPAN>FORMAT</SPAN><SPAN>(_SGA,</SPAN><SPAN>"#,##0.00;(#,##0.00)"</SPAN><SPAN>),</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>_selectedHeader = </SPAN><SPAN>"Operating Income"</SPAN><SPAN>, </SPAN><SPAN>FORMAT</SPAN><SPAN>((_Revenue+_COGS+_OCGS+_SGA),</SPAN><SPAN>"#,##0.00;(#,##0.00)"</SPAN><SPAN>), </SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>_selectedHeader = </SPAN><SPAN>"Operating Income Percentage"</SPAN><SPAN>, </SPAN><SPAN>FORMAT</SPAN><SPAN>((_Revenue+_COGS+_OCGS+_SGA)/_Revenue,</SPAN><SPAN>"#0.0%;(#0.0%)"</SPAN><SPAN>),</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>_selectedHeader = </SPAN><SPAN>"Total Non Operating"</SPAN><SPAN>, </SPAN><SPAN>FORMAT</SPAN><SPAN>(_NOPEXP,</SPAN><SPAN>"#,##0.00;(#,##0.00)"</SPAN><SPAN>),</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>_selectedHeader = </SPAN><SPAN>"Net Income"</SPAN><SPAN>, </SPAN><SPAN>FORMAT</SPAN><SPAN>((_Revenue+_COGS+_OCGS+_SGA+_NOPEXP),</SPAN><SPAN>"#,##0.00;(#,##0.00)"</SPAN><SPAN>),</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>_Actuals</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>//FORMAT(_Actuals, "#,##0.00;(#,##0.00)")</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>)</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>Return</SPAN><SPAN> _Results</SPAN></FONT></DIV></DIV> Thu, 19 Dec 2024 22:26:55 GMT AshishKS 2024-12-19T22:26:55Z I need to supress the rows where the column sub-total has no value. https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/I-need-to-supress-the-rows-where-the-column-sub-total-has-no/m-p/4337661#M172237 <P>The show items with No data works, if I have not formatted the Amounts in my columns, but once I format it using DAX, this option doesn't work anymore.</P><P>This one is w/o formatting the amount column</P><P><img /></P><P> </P><P>This one is after formatting the Amount Columns(Month-Year)</P><P><img /></P><P> </P><P><FONT face="courier new,courier" size="2">My DAX for Visual 2 - What can I add here to suppress rows which have no data in the month columns!</FONT></P><DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>Actuals = </SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>VAR</SPAN><SPAN> _selectedHeader = </SPAN><SPAN>SELECTEDVALUE</SPAN><SPAN> ('a360_finance fin_PnL_Template2'[Level_1])</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>VAR</SPAN><SPAN> _Actuals = </SPAN><SPAN>FORMAT</SPAN><SPAN>([Actual Amount],</SPAN><SPAN>"#,##0.00;(#,##0.00)"</SPAN><SPAN>)</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>VAR</SPAN><SPAN> _IsLevel2Visible = </SPAN><SPAN>ISINSCOPE</SPAN><SPAN>('a360_finance fin_PnL_Template2'[Level_2])</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>VAR</SPAN><SPAN> _DisplayDetailCode = </SPAN><SPAN>SELECTEDVALUE</SPAN><SPAN>('a360_finance fin_PnL_Template2'[Highlight])</SPAN></FONT></DIV><BR /><DIV><FONT face="courier new,courier" size="2"><SPAN>VAR</SPAN><SPAN> _Revenue = </SPAN><SPAN>CALCULATE</SPAN><SPAN>([Actual Amount],</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>                               </SPAN><SPAN>REMOVEFILTERS</SPAN><SPAN>('a360_finance fin_PnL_Template2'),</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>                               'a360_finance fin_PnL_Template2'[Level_1] </SPAN><SPAN>IN</SPAN><SPAN> {</SPAN><SPAN>"Sales Revenue"</SPAN><SPAN>}</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>                               )</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>VAR</SPAN><SPAN> _COGS = </SPAN><SPAN>CALCULATE</SPAN><SPAN>([Actual Amount],</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>                               </SPAN><SPAN>REMOVEFILTERS</SPAN><SPAN>('a360_finance fin_PnL_Template2'),</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>                               'a360_finance fin_PnL_Template2'[Level_1] </SPAN><SPAN>IN</SPAN><SPAN> {</SPAN><SPAN>"Cost of Products Sold"</SPAN><SPAN>}</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>                               )</SPAN></FONT></DIV><BR /><DIV><FONT face="courier new,courier" size="2"><SPAN>VAR</SPAN><SPAN> _CM = </SPAN><SPAN>CALCULATE</SPAN><SPAN>([Actual Amount],</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>                               </SPAN><SPAN>REMOVEFILTERS</SPAN><SPAN>('a360_finance fin_PnL_Template2'),</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>                               'a360_finance fin_PnL_Template2'[Level_1] </SPAN><SPAN>IN</SPAN><SPAN> {</SPAN><SPAN>"Sales Revenue"</SPAN><SPAN>,</SPAN><SPAN>"Cost of Products Sold"</SPAN><SPAN>}</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>                               )</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>VAR</SPAN><SPAN> _OCGS = </SPAN><SPAN>CALCULATE</SPAN><SPAN>([Actual Amount],</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>                               </SPAN><SPAN>REMOVEFILTERS</SPAN><SPAN>('a360_finance fin_PnL_Template2'),</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>                               'a360_finance fin_PnL_Template2'[Level_1] </SPAN><SPAN>IN</SPAN><SPAN> {</SPAN><SPAN>"Other COGS"</SPAN><SPAN>}</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>                               )</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>VAR</SPAN><SPAN> _SGA = </SPAN><SPAN>CALCULATE</SPAN><SPAN>([Actual Amount],</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>                               </SPAN><SPAN>REMOVEFILTERS</SPAN><SPAN>('a360_finance fin_PnL_Template2'),</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>                               'a360_finance fin_PnL_Template2'[Level_1] </SPAN><SPAN>IN</SPAN><SPAN> {</SPAN><SPAN>"SGA"</SPAN><SPAN>}</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>                                )</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>VAR</SPAN><SPAN> _NOPEXP = </SPAN><SPAN>CALCULATE</SPAN><SPAN>([Actual Amount],</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>                               </SPAN><SPAN>REMOVEFILTERS</SPAN><SPAN>('a360_finance fin_PnL_Template2'),</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>                               'a360_finance fin_PnL_Template2'[Level_1] </SPAN><SPAN>IN</SPAN><SPAN> {</SPAN><SPAN>"Non Operating"</SPAN><SPAN>}</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>                                )</SPAN></FONT></DIV><BR /><BR /><BR /><DIV><FONT face="courier new,courier" size="2"><SPAN>VAR</SPAN><SPAN> _Results = </SPAN><SPAN>SWITCH</SPAN><SPAN>(</SPAN><SPAN>TRUE</SPAN><SPAN>(),</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>_IsLevel2Visible = </SPAN><SPAN>TRUE</SPAN><SPAN>() && _DisplayDetailCode = </SPAN><SPAN>1</SPAN><SPAN>, </SPAN><SPAN>Blank</SPAN><SPAN>(),</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>_selectedHeader = </SPAN><SPAN>"Revenue"</SPAN><SPAN>, </SPAN><SPAN>FORMAT</SPAN><SPAN>(_Revenue, </SPAN><SPAN>"#,##0.00;(#,##0.00)"</SPAN><SPAN>),</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>_selectedHeader = </SPAN><SPAN>"Cost of  Goods Sold"</SPAN><SPAN>, </SPAN><SPAN>FORMAT</SPAN><SPAN>(_COGS,</SPAN><SPAN>"#,##0.00;(#,##0.00)"</SPAN><SPAN>),</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>_selectedHeader = </SPAN><SPAN>"Contribution Margin"</SPAN><SPAN>,  </SPAN><SPAN>FORMAT</SPAN><SPAN>(_CM,</SPAN><SPAN>"#,##0.00;(#,##0.00)"</SPAN><SPAN>),</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>_selectedHeader = </SPAN><SPAN>"Contribution Margin Percentage"</SPAN><SPAN>, </SPAN><SPAN>FORMAT</SPAN><SPAN>((_CM/_Revenue), </SPAN><SPAN>"#0.0%;(#0.0%)"</SPAN><SPAN>),</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>_selectedHeader = </SPAN><SPAN>"Other Cost of Goods Sold"</SPAN><SPAN>, </SPAN><SPAN>FORMAT</SPAN><SPAN>(_OCGS,</SPAN><SPAN>"#,##0.00;(#,##0.00)"</SPAN><SPAN>),</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>_selectedHeader = </SPAN><SPAN>"Total COGS"</SPAN><SPAN>, </SPAN><SPAN>FORMAT</SPAN><SPAN>(_COGS+_OCGS,</SPAN><SPAN>"#,##0.00;(#,##0.00)"</SPAN><SPAN>),</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>_selectedHeader = </SPAN><SPAN>"Gross Profit"</SPAN><SPAN>, </SPAN><SPAN>FORMAT</SPAN><SPAN>(_Revenue+_COGS+_OCGS,</SPAN><SPAN>"#,##0.00;(#,##0.00)"</SPAN><SPAN>),</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>_selectedHeader = </SPAN><SPAN>"Gross Profit Percentage"</SPAN><SPAN>, </SPAN><SPAN>FORMAT</SPAN><SPAN>((_Revenue+_COGS+_OCGS)/_Revenue,</SPAN><SPAN>"#0.0%;(#0.0%)"</SPAN><SPAN>),</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>_selectedHeader = </SPAN><SPAN>"Total SGA"</SPAN><SPAN>, </SPAN><SPAN>FORMAT</SPAN><SPAN>(_SGA,</SPAN><SPAN>"#,##0.00;(#,##0.00)"</SPAN><SPAN>),</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>_selectedHeader = </SPAN><SPAN>"Total Operating Expenses"</SPAN><SPAN>, </SPAN><SPAN>FORMAT</SPAN><SPAN>(_SGA,</SPAN><SPAN>"#,##0.00;(#,##0.00)"</SPAN><SPAN>),</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>_selectedHeader = </SPAN><SPAN>"Operating Income"</SPAN><SPAN>, </SPAN><SPAN>FORMAT</SPAN><SPAN>((_Revenue+_COGS+_OCGS+_SGA),</SPAN><SPAN>"#,##0.00;(#,##0.00)"</SPAN><SPAN>), </SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>_selectedHeader = </SPAN><SPAN>"Operating Income Percentage"</SPAN><SPAN>, </SPAN><SPAN>FORMAT</SPAN><SPAN>((_Revenue+_COGS+_OCGS+_SGA)/_Revenue,</SPAN><SPAN>"#0.0%;(#0.0%)"</SPAN><SPAN>),</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>_selectedHeader = </SPAN><SPAN>"Total Non Operating"</SPAN><SPAN>, </SPAN><SPAN>FORMAT</SPAN><SPAN>(_NOPEXP,</SPAN><SPAN>"#,##0.00;(#,##0.00)"</SPAN><SPAN>),</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>_selectedHeader = </SPAN><SPAN>"Net Income"</SPAN><SPAN>, </SPAN><SPAN>FORMAT</SPAN><SPAN>((_Revenue+_COGS+_OCGS+_SGA+_NOPEXP),</SPAN><SPAN>"#,##0.00;(#,##0.00)"</SPAN><SPAN>),</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>_Actuals</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>//FORMAT(_Actuals, "#,##0.00;(#,##0.00)")</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>)</SPAN></FONT></DIV><DIV><FONT face="courier new,courier" size="2"><SPAN>Return</SPAN><SPAN> _Results</SPAN></FONT></DIV></DIV> Thu, 19 Dec 2024 22:26:55 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/I-need-to-supress-the-rows-where-the-column-sub-total-has-no/m-p/4337661#M172237 AshishKS 2024-12-19T22:26:55Z Re: I need to supress the rows where the column sub-total has no value. https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/I-need-to-supress-the-rows-where-the-column-sub-total-has-no/m-p/4338006#M172250 <P>Hi <a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="848361" data-lia-user-login="AshishKS" class="lia-mention lia-mention-user">AshishKS</a> ,<BR /><BR />This is not possible, it means that both your column and row attributes will be gone. But the others are still populated with data, so it will be blank.<BR /><BR /></P> <P><SPAN>Hope it helps!</SPAN></P> <P> </P> <P>Best regards,<BR />Community Support Team_ Scott Chang</P> <P> </P> <P>If this post helps then please consider <STRONG>Accept it as the solution</STRONG> to help the other members find it more quickly.</P> <P><LI-WRAPPER></LI-WRAPPER></P> <P><BR /><BR /><BR /></P> Fri, 20 Dec 2024 05:24:22 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/I-need-to-supress-the-rows-where-the-column-sub-total-has-no/m-p/4338006#M172250 Anonymous 2024-12-20T05:24:22Z