Forum Discussion
SUMIF accross different tables
Hi,
In Power BI I try to replicate something which in Excel was a simple SUMIF, but I can't get it working.
In TableA I have a list of customers with some other basic data. It has the unique column [Identifier]. In TableB I have an overview of the amount (TableB[Tikken]) they have used in a certain month. It has the same identifier (called [IdentifierBetTik]), every month is on a seperate rule, so it is a many-to-one relation (single) from TableB to TableA. Most analysis are made from TableB, they work out fine.
I want one analysis the other way around: it is possible that there are rules in [Identifier] that don't exist in TableB, because the specific customer doesn't use it in one or several months. So I want to get an overview of those customers, and thought to fix it with a SUMIF-like solution, but all I get is errors with SUMX, FILTER or CALCULATE.
Can you help me with the formula I need to get the total sum of TableB[Tikken] for every (unique) rule of TableA[Identifier]?
1 Reply
Hi NLblabla ,
I could think of some functions such as SWITCH(), IF() and FILTER() according to your description but I don’t know where to start without a data model.
It's better to share some sample data and expected result.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Best Regards,
Jay
