Difference between values in two tables

[sraj]

Hi,

I am using this measure to find the variance between two values in different table.

Diff = Sum(2022_comparison[owner]) - sum(2021_comparison[owner])

The measure is working fine as needed, but I wanted to see if it's possible to not show the difference if both the values dont exist.  Here you can see no values for Owner 2022 in 5/25 to 5/31, but the diff still shows -94093, -94054, -93996 and so.  That's what I dont want to be shown on here.  

Can someone please advise?  Thank you!

[amitchandak · Accepted solution]

@sraj , Try a measure like

Diff =
Var _1 = Sum(2022_comparison[owner])
var _2 = sum(2021_comparison[owner])
return
if( not(isblank(_1)) && not(isblank(_2)) , _1-_2 , blank())