Hi All,

request your help to know the dax formula for the below calculation in power pivot calculated field.

REGION AMOUNT

EAST 1000
WEST 2000
NORTH 3500
SOUTH 4000
EAST 500
NORTH 1000
SOUTH 2000



RESULT

EAST +WEST----------------------- 3500
EAST +WEST- NORTH------------ -1000
SOUTH/EAST---------------------- 4
(EAST*WEST)/NORTH----------- 667