Comparison Costing model- Measures don't add up correctly

[KateD]

Hi,

I am trying to add 3 measures together from 3 seperate cards, however the Dax formula isn't giving me to correct answer. I belive it is to do with the slicers and ineratctions however I can't crack the answer! Unfortunaty the data is sensitive so I cant share the file but I will share some screen shots and what I have tried!

I need to add together the Net revenue/ head for option 2, 3 and 4 to compare to option 1.

DAX Formula that I have tried: 

Total Net Revenue / Head option 2 = [Net Revenue / Head 2] + [Net Revenue / Head 3] + [Net Revenue / Head 4]

Answer returns $8.46

Correct answer should be $105.13 + $79.91 + $8.39 = $193.43

**Each card works off a seperate slicer

I have also tried:

Net Rev / hd comp = SUMX(VALUES('Table', ( [Net Revenue / Head 2]) + [Net Revenue / Head 3] +[Net Revenue / Head 4]))

Total Net Revenue / Head option 2 = VALUE([Net Revenue / Head 2] + VALUE([Net Revenue / Head 3] + VALUE ([Net Revenue / Head 4])))

[KateD]

Hi, Thanks for helping. My answer is now (blank)

[amitchandak]

@KateD , Values need ac groping column

try
SUMX('Table', ( [Net Revenue / Head 2]) + [Net Revenue / Head 3] +[Net Revenue / Head 4])

or

SUMX(values('Table'[Revenue Head]), ( [Net Revenue / Head 2]) + [Net Revenue / Head 3] +[Net Revenue / Head 4])

Change column in bold with correct column