Net Sales as negative (negative sign numbers by Operating System Setting)

Value scenario:

Real amount as negative (false value)

Budget amount as positive (true value)

Take the amount greater than -1, [Net Sales] > -1 in order to CALCULATE them, filtering by text "Budget-2021" multiplying by -1, *-1, in order to keep the negative sign numbers by Operating System Setting. If value is false, it means negative numbers. Here you can get Real amount + Budget amount as negative, finally a Rolling Report (Real + Budget).

Measure:

Net Sale Rolling = IF([Net Sales] > -1,CALCULATE([Net Sale],Table'[Class] = "Budget-2021")*-1,[Net Sales])

Syntax

CALCULATE(<expression>[, <filter1> [, <filter2> [, …]]])

IF(<logical_test>, <value_if_true>[, <value_if_false>])