Diff % and money

[netanel]

Hello everyone
I am trying to write two formulas 
one That will bring me the change in percentages and one in money
I'm not getting the right numbers,
Would appreciate help
Attaches the formulas

1. Diff $ = CALCULATE(SUMX('Revenues DB','Revenues DB'[Net USD average per Day]-'Revenues DB'[Net USD average per Day LM]))

2. Net USD LM % difference from Net USD average per Day1 =

VAR __BASELINE_VALUE = [Net USD average per Day]

VAR __VALUE_TO_COMPARE = [Net USD average per Day for Budget 2021]

Var _Variance = if(ISBLANK(__VALUE_TO_COMPARE),0,__VALUE_TO_COMPARE - __BASELINE_VALUE)

RETURN

DIVIDE(_Variance, __BASELINE_VALUE)

[amitchandak · Accepted solution]

@netanel ,

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

The two need to measures no column

Diff $ = 'Revenues DB'[Net USD average per Day]-[Net USD average per Day LM]

Try for a second one

Net USD LM % difference from Net USD average per Day1 =
VAR __BASELINE_VALUE = [Net USD average per Day]
VAR __VALUE_TO_COMPARE = [Net USD average per Day for Budget 2021]
RETURN
DIVIDE(__VALUE_TO_COMPARE - __BASELINE_VALUE, __BASELINE_VALUE)