Difference between two amounts (Measures or columns)

[Nanakwame]

Hi All,

I am building a dashboard off sales data with sales values, back order amount values, open order amount values etc. 

I have a trend graph showing back order amount values and open order amount by month. 

I am looking for a dax function to calculate the difference between the 2 measures (back order amount and open order amount). Please note that the x axis is a drill down so it can be drilled down by quater, week etc. I will prefer for this dax function to take the drill down values into consideration. 

Please see image of graph below

[VahidDM · Accepted solution]

Hi @Nanakwame 

Try this:

Variance = [Back Order Amount]-[Open Order Amount]

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

Appreciate your Kudos!!

[Nanakwame]

That worked Sir. What if i wanted to create the percent difference of between the two?

[VahidDM]

Percent Variance =
Var _Variance =[Back Order Amount]-[Open Order Amount]
return
_Variance/[Back Order Amount]   //or _Variance/[Open Order Amount]

Change the format to percentage. 

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

Appreciate your Kudos!!