Calculating $ and % Variance in DAX

[williamadams12]

I'm struggling to get something really simple correct here. 

Current Matrix:

Financials	Actuals	Forecast	VAR $	VAR %
Revenue	$9,375,398	$10,119,803	($744,405)	-7.4%
EBITDA	($523,357)	($358,524)	($164,833)	46%

Desired Matrix:

Financials	Actuals	Forecast	VAR $	VAR %
Revenue	$9,375,398	$10,119,803	($744,405)	-7.4%
EBITDA	($523,357)	($358,524)	($164,833)	-46%

Actuals, Forecast, VAR $ and VAR % are all calculated measures; only the Revneue and EBITDA Row Headers are values from an imported table. I want the VAR % to be negative when comparing the variance of two negative figures; for example in the first table the VAR % vs the Forecast is -46%, since $164k is roughly 46% of $358k. 

VAR % Measure:

VAR % = DIVIDE([VAR $], [Forecast])

The measure, ideally, should calculate the variance for the row values of "Revenue" and "EBITDA" in the Financials. 

Any ideas? 

[tamerj1]

Hi @williamadams12 
Please use 

VAR % =
- ABS ( DIVIDE ( [VAR $], [Forecast] ) )

[williamadams12]

This doesn't work; it renders positive amounts negative when the $ variance is positive, which is incorrect. 

[tamerj1 · Accepted solution]

@williamadams12 
You are 100% correct. Please try

VAR % =
DIVIDE ( [VAR $], ABS ( [Forecast] ) )