https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-help-with-filtering-between-two-table/m-p/3047433#M104807 <P>hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="505588" data-lia-user-login="Trahman1971" class="lia-mention lia-mention-user">Trahman1971</a>&nbsp;</P><P>how are table1 and table2 related?</P> Fri, 27 Jan 2023 14:39:02 GMT FreemanZ 2023-01-27T14:39:02Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-help-with-filtering-between-two-table/m-p/3047253#M104793 <P>Hello, I am trying to find a way to filter data from few columns and between two tables.&nbsp;</P><P>&nbsp;</P><P>My goal is to calculate total "payload_reporting" that sent to PC01.&nbsp;</P><P>&nbsp;</P><P><img /></P><P>payload_reporting is in table1.&nbsp;</P><P>&nbsp;</P><P>Here are the filter that I have to take care:&nbsp;</P><P>1. From table 1&nbsp;</P><P><img /></P><P>&nbsp;</P><P>2. From table 2:&nbsp;</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>Could anyone help me with this ? Thank you&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Fri, 27 Jan 2023 13:16:19 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-help-with-filtering-between-two-table/m-p/3047253#M104793 Trahman1971 2023-01-27T13:16:19Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-help-with-filtering-between-two-table/m-p/3047433#M104807 <P>hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="505588" data-lia-user-login="Trahman1971" class="lia-mention lia-mention-user">Trahman1971</a>&nbsp;</P><P>how are table1 and table2 related?</P> Fri, 27 Jan 2023 14:39:02 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-help-with-filtering-between-two-table/m-p/3047433#M104807 FreemanZ 2023-01-27T14:39:02Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-help-with-filtering-between-two-table/m-p/3047449#M104808 <P><img /></P><P>&nbsp;</P> Fri, 27 Jan 2023 14:44:21 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-help-with-filtering-between-two-table/m-p/3047449#M104808 Trahman1971 2023-01-27T14:44:21Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-help-with-filtering-between-two-table/m-p/3047452#M104809 <P><img /></P><P>&nbsp;</P> Fri, 27 Jan 2023 14:45:43 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-help-with-filtering-between-two-table/m-p/3047452#M104809 Trahman1971 2023-01-27T14:45:43Z