topic Re: display row based on two columns in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/display-row-based-on-two-columns/m-p/4210862#M166952 <P>Thank you so much, yes the description was incorrect about the first row, but the solution worked perfect.&nbsp;</P> Wed, 02 Oct 2024 03:00:30 GMT hnb_tor 2024-10-02T03:00:30Z display row based on two columns https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/display-row-based-on-two-columns/m-p/4209843#M166924 <P>Hi,&nbsp;</P><P>&nbsp;</P><P>I have a table like shown below, I dont want to display rows when Regional Total Orders = 0 and Customer Total Orders &gt; 0, but all other rows should be displayed. Could someone please help ? I tried the IF(AND(COND1, COND2), "True", "False) but I'm running into issues.&nbsp;</P><DIV class="">&nbsp;</DIV><P>&nbsp;</P><TABLE border="2"><TBODY><TR><TD>Customer</TD><TD>Department</TD><TD>Region</TD><TD>Orders</TD><TD>Regional Total Orders</TD><TD>Customer Total Orders</TD><TD>&nbsp;</TD></TR><TR><TD>A Corp</TD><TD>Sales</TD><TD>Asia</TD><TD>0</TD><TD>2</TD><TD>7</TD><TD>Don’t Display this Row</TD></TR><TR><TD>A Corp</TD><TD>Marketing</TD><TD>Asia</TD><TD>2</TD><TD>2</TD><TD>7</TD><TD>Display this Row</TD></TR><TR><TD>A Corp</TD><TD>R&amp;D</TD><TD>Europe</TD><TD>5</TD><TD>5</TD><TD>7</TD><TD>Display this Row</TD></TR><TR><TD>B Corp</TD><TD>Sales</TD><TD>Americas</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>Display this Row</TD></TR><TR><TD>B Corp</TD><TD>Procurement</TD><TD>Americas</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>Display this Row</TD></TR><TR><TD>B Corp</TD><TD>Research</TD><TD>Europe</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>Display this Row</TD></TR><TR><TD>C Corp</TD><TD>Sales</TD><TD>Americas</TD><TD>0</TD><TD>0</TD><TD>24</TD><TD>Don’t Display this Row</TD></TR><TR><TD>C Corp</TD><TD>Marketing</TD><TD>Americas</TD><TD>0</TD><TD>0</TD><TD>24</TD><TD>Don’t Display this Row</TD></TR><TR><TD>C Corp</TD><TD>HR</TD><TD>Asia</TD><TD>10</TD><TD>24</TD><TD>24</TD><TD>Display this Row</TD></TR><TR><TD>C Corp</TD><TD>Finance&nbsp;</TD><TD>Asia</TD><TD>14</TD><TD>24</TD><TD>24</TD><TD>Display this Row</TD></TR></TBODY></TABLE><P>&nbsp;</P><DIV class="">&nbsp;</DIV><DIV class="">&nbsp;</DIV><P>&nbsp;</P><DIV class="">&nbsp;</DIV><P>&nbsp;</P><P>&nbsp;</P> Tue, 01 Oct 2024 18:39:18 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/display-row-based-on-two-columns/m-p/4209843#M166924 hnb_tor 2024-10-01T18:39:18Z Re: display row based on two columns https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/display-row-based-on-two-columns/m-p/4210260#M166932 <P>Why should your first row be excluded? Regional Total Orders for A Corp Sales Asia is not 0.</P> <P>&nbsp;</P> <P><img /></P> <P>&nbsp;</P> Tue, 01 Oct 2024 20:43:48 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/display-row-based-on-two-columns/m-p/4210260#M166932 lbendlin 2024-10-01T20:43:48Z Re: display row based on two columns https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/display-row-based-on-two-columns/m-p/4210862#M166952 <P>Thank you so much, yes the description was incorrect about the first row, but the solution worked perfect.&nbsp;</P> Wed, 02 Oct 2024 03:00:30 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/display-row-based-on-two-columns/m-p/4210862#M166952 hnb_tor 2024-10-02T03:00:30Z