Forum Discussion
Solved
Incorrect measure values
Hi All,
I have created a measure with the below logic.
When I use this measure in a table with locn_terr_code and locn field, I get the expected result.
But, when I use the measure with only locn_Terr_code, I am getting inccorect value. Result is showing as zero instead of 1.
Values are not getting summarized.
Could somone help resolve this.
Thank you.
NewMeasure=SUMX(VALUES(Table[LOCN]),CALCULATE(your code))
1 Reply
NewMeasure=SUMX(VALUES(Table[LOCN]),CALCULATE(your code))