Based on 2 measures can the calculation work or return null?

[deepakv]

Hi Community,

With the below table 

If any of the measure (Cost) and measure(Prior quarter values) contains nulls the Variance column should not perform the calculation, If both the measures contains values then the variance should pop up with correct totals as I am observing the wrong sum of total for each measure.

For totals to be correct i have used-

SUMX(GROUPBY(TABLE,TABLE[PRODUCT]),CALCULATE( [Prior quarter]-[Cost]))

Any help would be helpful.

@Greg_Deckler 

Product	Cost	prior quarter values	Variance (C-B)
A	10000	9000	-1000
B	20000	0	-20000
D	0	5000	5000
E	10000	7000	-3000
C	30000	0	-30000
G	0	15000	15000
D	15000	14000	-1000
C	30000	0	-30000

[deepakv]

Thank you it worked @amitchandak 

[amitchandak · Accepted solution]

@deepakv ,

variance = if(not(isblank([COst])) && not(isblank([prior quarter values]))  , [prior quarter values] -[Cost], blank())

or

variance =Sumx(values(Table[Product]), calculate(  if(not(isblank([COst])) && not(isblank([prior quarter values]))  , [prior quarter values] -[Cost], blank()))