topic A measure that also sums values ​​from other categories in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/A-measure-that-also-sums-values-from-other-categories/m-p/2943871#M97321 <P>Hi everyone <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span>&nbsp;</P><P>I have a problem to solve that I can't handle and I really believe in the power of community.</P><P>&nbsp;</P><P>After simplification, I have two tables, the first one with the product. Where for each product we have the price and the financing company, the financing company can be blank (if we bought the product with our own funds)</P><TABLE><TBODY><TR><TD>productId&nbsp;</TD><TD>price</TD><TD>Financing_comapany_id</TD></TR><TR><TD>1</TD><TD>100</TD><TD>10</TD></TR><TR><TD>2</TD><TD>200</TD><TD>11</TD></TR><TR><TD>3</TD><TD>500</TD><TD>10</TD></TR><TR><TD>4</TD><TD>1000</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>in the second table we have financing conditions for individual companies. That is, what percentage of the product amount is financed by own funds and what percentage by the financing company</P><TABLE><TBODY><TR><TD>financing_company_id</TD><TD>downpayment</TD><TD>financing</TD></TR><TR><TD>10</TD><TD>10%</TD><TD>90%</TD></TR><TR><TD>11</TD><TD>50%</TD><TD>50%</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>What I would like to achieve is to create a measure that would calculate for each financing company the value of the capital involved in accordance with the terms of financing. That is, the price multiplied by the percentage of financing</P><P>That is, for product "1" it would be 100*90%=90</P><P>&nbsp;</P><P>Complications occur with the financing company "blank" because for it, apart from the value of product prices for which financing_company is blank, I would also like to sum up the product values ​​multiplied by the downpayment value for products for which the financing company is not blank.</P><P>This is what the table I want looks like in report</P><TABLE><TBODY><TR><TD>product/financing_company_id</TD><TD>&nbsp;</TD><TD>10</TD><TD>11</TD></TR><TR><TD>product1</TD><TD>10</TD><TD>90</TD><TD>&nbsp;</TD></TR><TR><TD>product2</TD><TD>100</TD><TD>&nbsp;</TD><TD>100</TD></TR><TR><TD>product3</TD><TD>50</TD><TD>450</TD><TD>&nbsp;</TD></TR><TR><TD>product4</TD><TD>1000</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>thanks in advance for any help <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Fri, 02 Dec 2022 07:53:27 GMT Anonymous 2022-12-02T07:53:27Z A measure that also sums values ​​from other categories https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/A-measure-that-also-sums-values-from-other-categories/m-p/2943871#M97321 <P>Hi everyone <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span>&nbsp;</P><P>I have a problem to solve that I can't handle and I really believe in the power of community.</P><P>&nbsp;</P><P>After simplification, I have two tables, the first one with the product. Where for each product we have the price and the financing company, the financing company can be blank (if we bought the product with our own funds)</P><TABLE><TBODY><TR><TD>productId&nbsp;</TD><TD>price</TD><TD>Financing_comapany_id</TD></TR><TR><TD>1</TD><TD>100</TD><TD>10</TD></TR><TR><TD>2</TD><TD>200</TD><TD>11</TD></TR><TR><TD>3</TD><TD>500</TD><TD>10</TD></TR><TR><TD>4</TD><TD>1000</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>in the second table we have financing conditions for individual companies. That is, what percentage of the product amount is financed by own funds and what percentage by the financing company</P><TABLE><TBODY><TR><TD>financing_company_id</TD><TD>downpayment</TD><TD>financing</TD></TR><TR><TD>10</TD><TD>10%</TD><TD>90%</TD></TR><TR><TD>11</TD><TD>50%</TD><TD>50%</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>What I would like to achieve is to create a measure that would calculate for each financing company the value of the capital involved in accordance with the terms of financing. That is, the price multiplied by the percentage of financing</P><P>That is, for product "1" it would be 100*90%=90</P><P>&nbsp;</P><P>Complications occur with the financing company "blank" because for it, apart from the value of product prices for which financing_company is blank, I would also like to sum up the product values ​​multiplied by the downpayment value for products for which the financing company is not blank.</P><P>This is what the table I want looks like in report</P><TABLE><TBODY><TR><TD>product/financing_company_id</TD><TD>&nbsp;</TD><TD>10</TD><TD>11</TD></TR><TR><TD>product1</TD><TD>10</TD><TD>90</TD><TD>&nbsp;</TD></TR><TR><TD>product2</TD><TD>100</TD><TD>&nbsp;</TD><TD>100</TD></TR><TR><TD>product3</TD><TD>50</TD><TD>450</TD><TD>&nbsp;</TD></TR><TR><TD>product4</TD><TD>1000</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>thanks in advance for any help <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Fri, 02 Dec 2022 07:53:27 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/A-measure-that-also-sums-values-from-other-categories/m-p/2943871#M97321 Anonymous 2022-12-02T07:53:27Z Re: A measure that also sums values ​​from other categories https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/A-measure-that-also-sums-values-from-other-categories/m-p/2945867#M97452 <P>hi&nbsp;Anonymous</LI-USER>&nbsp;</P><P>in your expected result, it seems, for each product, price is 100% financed by Fin Com 10 and 11. Is there some misunderstanding?</P> Sat, 03 Dec 2022 10:07:51 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/A-measure-that-also-sums-values-from-other-categories/m-p/2945867#M97452 FreemanZ 2022-12-03T10:07:51Z