topic Exclude data from table in Power BI in Developer https://community.fabric.microsoft.com/t5/Developer/Exclude-data-from-table-in-Power-BI/m-p/2575221#M36659 <P>Hi,</P><P>&nbsp;</P><P>Having situation when calculating supply amount, it collect all rows. For example type contains sales, doubts etc, but one column values contains many values. How to exclude not required rows in order not damaging other types?</P> Mon, 13 Jun 2022 12:30:33 GMT Analitika 2022-06-13T12:30:33Z Exclude data from table in Power BI https://community.fabric.microsoft.com/t5/Developer/Exclude-data-from-table-in-Power-BI/m-p/2575221#M36659 <P>Hi,</P><P>&nbsp;</P><P>Having situation when calculating supply amount, it collect all rows. For example type contains sales, doubts etc, but one column values contains many values. How to exclude not required rows in order not damaging other types?</P> Mon, 13 Jun 2022 12:30:33 GMT https://community.fabric.microsoft.com/t5/Developer/Exclude-data-from-table-in-Power-BI/m-p/2575221#M36659 Analitika 2022-06-13T12:30:33Z Re: Exclude data from table in Power BI https://community.fabric.microsoft.com/t5/Developer/Exclude-data-from-table-in-Power-BI/m-p/2577626#M36692 <P>Hi,</P><P>You can use IN or NOT IN operators to select or exclude.</P><P>Refer -&nbsp;<A href="https://www.sqlbi.com/articles/the-in-operator-in-dax/" target="_blank">https://www.sqlbi.com/articles/the-in-operator-in-dax/</A></P><P>Thanks</P><P>Hari</P><P>&nbsp;</P><DIV class=""><DIV><STRONG>Did I answer your question? Then please mark my post as the solution.<BR />If I helped you, click on the Thumbs Up to give Kudos.</STRONG><BR /><BR /><A href="https://dataap.org/blog/author/hariharanr/" target="_blank" rel="noopener"><STRONG>My Blog</STRONG></A> :: <A href="https://www.youtube.com/c/HarisBI" target="_blank" rel="nofollow noopener noreferrer">YouTube Channel</A> :: <A href="https://www.linkedin.com/in/imhariharanr/" target="_blank" rel="nofollow noopener noreferrer">My Linkedin</A><BR /><BR /><BR /></DIV></DIV> Tue, 14 Jun 2022 12:34:17 GMT https://community.fabric.microsoft.com/t5/Developer/Exclude-data-from-table-in-Power-BI/m-p/2577626#M36692 Hariharan_R 2022-06-14T12:34:17Z