Forum Discussion
Solved
SumX is giving wrong value
Hi I am calcultaing sum of the measure but its giving me wrong value, all meaure gives wrong value on row lelvel but one measure give me correct value when i filter with product, What i am doing ...
alamhaz , what is correct level based on visual ?
try like
SUMX(summarize('Product Movement','Product Movement'[Date],'Product Movement'[Prod Key Value],"_1", [Avg Sale Lost]),[_1])
no, giving only one value 34