Forum Discussion
DAX Measure issue
Hi I have 2 tables in power bi desktop model. Payments(PayDate, CostCode, Amount) CostCodeMapping(CostCode, Region, Directorate) I have 1 to many relationship between CCMapping and Payments ...
Can you post an image of the final visual?
I have a feeling you don't need the filter expression "&& Payments[CostCode] IN VALUES(CCMapping[CostCode])", given you have aone-to-many relationship bewteen your tables.