https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-filter-units-by-company/m-p/3911630#M152322 <P>Thank you, very much!!&nbsp;<span class="lia-unicode-emoji" title=":thumbs_up:">👍</span></P> Sun, 12 May 2024 09:41:21 GMT Sleathbcn 2024-05-12T09:41:21Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-filter-units-by-company/m-p/3911343#M152320 <P>Hello, I would need help with a sales table. Let me explain, I have a unit sales table. In this table there are 5 companies, A,B,C,D and E. The units of company B are always incorrect. I would like to find a dax formula where the units of the companies add up without taking into account the units of B. Thank you very much.</P> Sat, 11 May 2024 23:32:51 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-filter-units-by-company/m-p/3911343#M152320 Sleathbcn 2024-05-11T23:32:51Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-filter-units-by-company/m-p/3911385#M152321 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="364334" data-lia-user-login="Sleathbcn" class="lia-mention lia-mention-user">Sleathbcn</a>&nbsp;,</P> <P>I am not sure about your exact table and column names, but there are many ways to get your required output, and one of them is as follows:</P> <P><img /></P> <P>Best regards,</P> Sun, 12 May 2024 00:36:07 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-filter-units-by-company/m-p/3911385#M152321 DataNinja777 2024-05-12T00:36:07Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-filter-units-by-company/m-p/3911630#M152322 <P>Thank you, very much!!&nbsp;<span class="lia-unicode-emoji" title=":thumbs_up:">👍</span></P> Sun, 12 May 2024 09:41:21 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-filter-units-by-company/m-p/3911630#M152322 Sleathbcn 2024-05-12T09:41:21Z