https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Data-Extraction-from-Unrelated-tables/m-p/3678442#M142829 <P>Hello all,</P><UL><LI>I have 3 tables, fact sales momthly, fact gross price and dim products.</LI><LI>dim products have one to many relation with both fact tables but the fact tables do not have any relation between them.</LI><LI>fact_sales_monthly have sales quantity column and fact_gross_price have gross_price column. I want to calculate sales_amount that is sales quantity*gross_price.</LI></UL><P>How to do it in dax or any other way ?<BR />I tried using RELATED(), CROSSFILTER(), LOOKUP(), didnt work out.<BR /><BR />I have attached the image of my datamodel.<img /></P> Sun, 04 Feb 2024 13:18:57 GMT Swam80 2024-02-04T13:18:57Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Data-Extraction-from-Unrelated-tables/m-p/3678442#M142829 <P>Hello all,</P><UL><LI>I have 3 tables, fact sales momthly, fact gross price and dim products.</LI><LI>dim products have one to many relation with both fact tables but the fact tables do not have any relation between them.</LI><LI>fact_sales_monthly have sales quantity column and fact_gross_price have gross_price column. I want to calculate sales_amount that is sales quantity*gross_price.</LI></UL><P>How to do it in dax or any other way ?<BR />I tried using RELATED(), CROSSFILTER(), LOOKUP(), didnt work out.<BR /><BR />I have attached the image of my datamodel.<img /></P> Sun, 04 Feb 2024 13:18:57 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Data-Extraction-from-Unrelated-tables/m-p/3678442#M142829 Swam80 2024-02-04T13:18:57Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Data-Extraction-from-Unrelated-tables/m-p/3678476#M142832 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="681124" data-lia-user-login="Swam80" class="lia-mention lia-mention-user">Swam80</a>&nbsp;I would think a column in your dim_product table like this should work:</P> <LI-CODE lang="markup">Column = VAR __Sold = SUMX(RELATEDTABLE('gdb023 fact_sales_monthly'), [sold_quantity]) VAR __Price = SUMX(RELATEDTABLE('gdb023 fact_sales_price'), [gross_price]) VAR __Result = __Sold * __Price RETURN __Result</LI-CODE> Sun, 04 Feb 2024 14:22:22 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Data-Extraction-from-Unrelated-tables/m-p/3678476#M142832 Greg_Deckler 2024-02-04T14:22:22Z