Aggregate a column in Table1 based on Match and No Match values from Table 2

Hi FMF ,

Please have a try.

Create a measure.

KPI_DAX = 
var result_1= CALCULATE(SUM('Table 1'[KPI]),FILTER(ALL('Table 1'),'Table 1'[Company]=SELECTEDVALUE('Table 1'[Company])&&[Check]="Match"))
var result_2=CALCULATE(SUM('Table 1'[KPI]),FILTER(ALL('Table 1'),'Table 1'[Company]=SELECTEDVALUE('Table 1'[Company])&&[Check]="Not Match"))
var answer = IF([Check]="Match",result_1,result_2)
return answer

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.