Forum Discussion
SkorpionAAM
Helper V
6 years agoWrong 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...
Anonymous
6 years agoNot applicable
Hi SkorpionAAM
I would create a column as below
CALCULATE(sum(table[sum_covered]),allexcept(table,table[road Side]))
and use max while plotting if required.
Did I resolve your issue? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!!
Regards,
Pranit
SkorpionAAM
Helper V
6 years agoThis Already in measure so i cant use Sum in Measure
- Anonymous6 years agoNot applicable
HI SkorpionAAM
try...
CALCULATE(sumx(table[sum_covered]),allexcept(table,table[road Side]))
Did I resolve your issue? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!!
Regards,
Pranit- SkorpionAAM6 years ago
Helper V
no
- Anonymous6 years agoNot applicable
HI SkorpionAAM
try MAXX instead of SUMX
Did I resolve your issue? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!!
Regards,
Pranit