Forum Discussion
Comparing values between different tables
Ok. If you're using Power BI Desktop you just need to apply both your tables to the model, relate LIST to CONTAINER on CONTAINER[COD] 1 = * LIST[COD] (assuming your CONTAINER table contains a UNIQUE list of customers), then drag CONTAINER[COD] and LIST[VALUE] columns into a visual. PBI will automatically aggregate the result giving you what it sounds like you're after.
If this is to be done in Excel, then probably easiest to just do a merge in PQ instead of a relationship as described above in the model.
Pete
Use merge query in Power Query, or load the data into the model and use DAX to calculate (aggregate and then determine whether it is greater than 0).
BA_Pete Why use PQ in Excel for this? Does PowerPivot not support the functions you use
It does but, in my experience, Excel users rarely want to get into PowerPivot modeling. If they did, they'd probably be using PBI already.
Pete