Showing results for 
Search instead for 
Did you mean: 
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


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



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
product2100 100


thanks in advance for any help 🙂

Community Champion
Community Champion

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

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors