Creating a Dax query to get sum of a column from Table A if the record matches in Table B
I have 2 tables 1. Gold_Staff_Campaign 2. FX_Data i want to create a DAX formula to calculate the Total Profit residing in Table FX_Data under column "Profit" if the Account Number in Gold_Staff_Campaign matches with Account Number in FX_Data. I have tried below formula but its not working 1. ProfitColumn = VAR CurrentFORACID = SELECTCOLUMNS ( Gold_Diwali_Campaign, "FORACID", Gold_Diwali_Campaign[FORACID] ) RETURN CALCULATE ( SUM ( FX_Data_2022_Onwards[Profit w.r.t real time rate(AED)] ), FILTER ( FX_Data_2022_Onwards, FX_Data_2022_Onwards[FORACID] = CurrentFORACID ),ALL ( Gold_Diwali_Campaign ) )