cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Route11 Member
Member

Subtracting two variables in DAX

Hi Experts

 

How would you subtract the following...

 

A1 France-Benelux VPY%1 = 
Var FB = CALCULATE([NSvPY1% (Reported PY)], FILTER(
        'Reporting Hierarchy 2','Reporting Hierarchy 2'[Tweaked Franchise]="INFUSION DEVICES"), FILTER(
        'Reporting Hierarchy 2','Reporting Hierarchy 2'[Tweaked Sub Region] IN {"French Region","BENELUX Region"}))

VAR FBN =  CALCULATE([NSvPY1% (Reported PY)], FILTER(Management,Management[Level5] IN {"French Region","BENELUX Region"}))
Return
1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Subtracting two variables in DAX

Hi @Route11,

 

What do you mean by subtracting two variables? If they are numeric, just one minus another like this FB - FBN. Can you share a dummy sample and some snapshots to make it clear, please?

 

 

Best Regards,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support Team
Community Support Team

Re: Subtracting two variables in DAX

Hi @Route11,

 

What do you mean by subtracting two variables? If they are numeric, just one minus another like this FB - FBN. Can you share a dummy sample and some snapshots to make it clear, please?

 

 

Best Regards,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Route11 Member
Member

Re: Subtracting two variables in DAX

Hi thanks for the feedback managed to resolve the issue

 

VAR 1

VAR 2

VAR 3 = VAR 1- VAR2

Return

VAR 3