https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Groupby-values-from-2-non-related-tables/m-p/1849535#M39508 <P><SPAN>Is there a way to SUMMARIZE 2 fact tables (Fact_Revenue and Fact_Expenses etc.) using one field on one of the fact table (For Example I have the client name in the Fact_Revenue table but I do not have it in any dimension or in the other Fact_Expenses table) But I want to summarize Expenses and Revenue by Client names. There is no relationship between these 2 fact tables as well. Please help.</SPAN></P> Tue, 18 May 2021 20:15:23 GMT kasun909 2021-05-18T20:15:23Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Groupby-values-from-2-non-related-tables/m-p/1849535#M39508 <P><SPAN>Is there a way to SUMMARIZE 2 fact tables (Fact_Revenue and Fact_Expenses etc.) using one field on one of the fact table (For Example I have the client name in the Fact_Revenue table but I do not have it in any dimension or in the other Fact_Expenses table) But I want to summarize Expenses and Revenue by Client names. There is no relationship between these 2 fact tables as well. Please help.</SPAN></P> Tue, 18 May 2021 20:15:23 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Groupby-values-from-2-non-related-tables/m-p/1849535#M39508 kasun909 2021-05-18T20:15:23Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Groupby-values-from-2-non-related-tables/m-p/1849646#M39512 <P>If you do not have anything that references or relates to the client in the expense table, then how do you tell which expense belongs to which client?</P> Tue, 18 May 2021 21:47:22 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Groupby-values-from-2-non-related-tables/m-p/1849646#M39512 Anonymous 2021-05-18T21:47:22Z