How do I use sum instead of the measure used?

[Anonymous]

Hey,

this problem has been driving me bananas. I have this measure: 

Position* WAC weights= WAC Final

Everything works perfectly but the total, I am trying to sum the WAC final numbers in total. This should lead to 4.23+ 4.21=8.44 whereas now it shows 8.75.

So what is happening is that in the total row Position (8.75) is multiplied by WAC weight (1) this gives us WAC Final which is incorrect (8.75). Any idea how to sum the numbers from the rows instead of calculating the total using the measure. It can also be a new measure. 

Looking forward to your recommendations!

[amitchandak · Accepted solution]

@Anonymous , Need exact calculations for the formula

But a new measure, with Values as a group(Unsummarized columns) by visual can help.

Sumx(Values(Table[Group]), [WAC Final])

or

Sumx(Summarize(Table,Table[Group], Table[Group2], "_1", [WAC Final]),[_1])

[Anonymous]

Awesome, this worked!!