Calculations in Appended table

Hi Anonymous 

It appears three times because it is in a matrix visual. In a matrix visual, the Values field will be evaluated for every pair of column and row. From the screenshot, there are Act-Fcst, JQF22 and JRF22 column values, so it is evaluted for all of them. 

I guess your purpose is to calculate the difference between the current value and the respective JRF, right? If so, you can try this measure

Diff vs JRF = SUM('Table (2)'[Value]) - CALCULATE(SUM('Table (2)'[Value]),ALLSELECTED('Table (2)'[Version]),'Table (2)'[Version]="JRF22")

Similarly

Diff vs Budget = SUM('Table (2)'[Value]) - CALCULATE(SUM('Table (2)'[Value]),ALLSELECTED('Table (2)'[Version]),'Table (2)'[Version]="Budget")

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.