Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
equlibrum52
Frequent Visitor

A measure that also sums values ​​from other categories

Hi everyone 🙂 

I have a problem to solve that I can't handle and I really believe in the power of community.

 

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)

productId priceFinancing_comapany_id
110010
220011
350010
41000 

 

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

financing_company_iddownpaymentfinancing
1010%90%
1150%50%

 

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

That is, for product "1" it would be 100*90%=90

 

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.

This is what the table I want looks like in report

product/financing_company_id 1011
product11090 
product2100 100
product350450 
product41000  

 

thanks in advance for any help 🙂

1 REPLY 1
FreemanZ
Super User
Super User

hi @equlibrum52 

in your expected result, it seems, for each product, price is 100% financed by Fin Com 10 and 11. Is there some misunderstanding?

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.