Forum Discussion
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 road side its counting both side
as you can see left sde have 5 and right have 4
when i count sedment id its giving me 18
so i need result break down by road side output will be 5 on left and 4 on right
14 Replies
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
SkorpionAAMThis Already in measure so i cant use Sum in Measure
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
- mahoneypat
Microsoft Employee
Please 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
- SkorpionAAM
SUMX(VALUES(Table[_50segment_id]), [Sum Covered])
Still giving 18
