Summarizing a measure based on another measure

[Anonymous]

Hello,

I have need to summarize scores based on a measure (breaks out percentages into a new column of 1's and 0's) that is already based on another measure that divides a numerator by denominator. One example is column T_60_65, taking a score between 60 and 65. When I try to create a new measure based on  T_60_65 (doing a sum), I get the error seen in the 2nd screenshot below. How can I get around this? thx!!

[tamerj1 · Accepted solution]

Hi @Anonymous 

try

SUMX ( VALUES ( TableName[Manager] ), [MeasureName] )

[tamerj1 · Accepted solution]

Hi @Anonymous 

try

SUMX ( VALUES ( TableName[Manager] ), [MeasureName] )

[Anonymous · Accepted solution]

Thx!! It worked