Measure not providing expected result for summing up row values

Anonymous — Fri, 31 Mar 2023 04:38:10 GMT

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

Re: Measure not providing expected result for summing up row values

ValtteriN — Fri, 31 Mar 2023 04:44:23 GMT

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/

topic Re: Measure not providing expected result for summing up row values in DAX Commands and Tips

Measure not providing expected result for summing up row values

Re: Measure not providing expected result for summing up row values