Forum Discussion
SkorpionAAM
Helper V
Helper VWrong Value shoing on Measure
I have measue where break down by road side Left and right side and there is numbers i measure if segment is gretaer then 0 then 1 and if not then 0 now new measure want to count all ones by...
mahoneypat
Microsoft Employee
Microsoft EmployeePlease try this expression instead, replacing with the correct table and column names.
NewMeasure = SUMX(VALUES(Table[_50segment_id]), [Sum Covered])
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
SkorpionAAMSUMX(VALUES(Table[_50segment_id]), [Sum Covered])
Still giving 18