Incorrect measure values

[poojithas]

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.

[wdx223_Daniel · Accepted solution]

NewMeasure=SUMX(VALUES(Table[LOCN]),CALCULATE(your code))