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]?
