Measure not providing expected result for summing up row values

[Anonymous]

hi

Im trying to create a measure which can aggregate sum value of "Cost" field based on field "Prog Id". I tried using the below DAX for the measure but the results are in "Received measure value". Any suggestion how i can get "Expected measure value".

Kindly note that the table visual has "Visual filters" + Page Level filters

CALCULATE(SUM(table[Cost]),ALLSELECTED(table[Prog id]))

Prog Id	WBS Id	Cost	Expected measure value	Received measure value
x	x1	-100	0	-100
x	x2	100	0	100
y	y1	-200	100	-200
y	y2	300	100	300
z	z1	400	900	400
z	z2	500	900	500

[ValtteriN · Accepted solution]

Hi,

Here is one way to do this:

Measure 44 = CALCULATE(SUM('Table (28)'[Cost]),ALLEXCEPT('Table (28)','Table (28)'[rog Id]))


End result:

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/