Forum Discussion

rajanimaddala's avatar
rajanimaddala
Icon for Helper II rankHelper II
5 years ago

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  ...
Need Help
Tips and Tricks
PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
5 years ago

rajanimaddala 

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.