Wrong Value shoing on Measure

[SkorpionAAM]

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

[mahoneypat]

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

[Anonymous]

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]

This Already in measure so i cant use Sum in Measure

[Anonymous]

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

[SkorpionAAM]

no

[Anonymous]

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

[SkorpionAAM]

Same .. shall i share the Power bi file to you if u dont mind

[Anonymous]

HI @SkorpionAAM 

Sure...

Regards,

Pranit

[SkorpionAAM]

please downlowd the File from here

https://drive.google.com/file/d/1m5P_f6-ssCiAbmXVkDyl837WnBGvgAG8/view?usp=sharing

when ypou dont summrized the Count of _50kmsegement_id then you will get the Value on measure on left and right

[Anonymous]

Hi @SkorpionAAM 

What is the folder and the file name?

Regards,

Pranit

[SkorpionAAM]

File Nme is

Gas Station Need and Road coverage analysis V21

[SkorpionAAM]

I uploazd as A zip file now u can download

[Anonymous]

Hi @SkorpionAAM ,

I gave it some time, The formula should work. its a simple requirement.

Looks like there are lot of table joins which I didn't get into for many to one or one to many.

But the fourmla should work also, The report doesn't have the first chart you mentioned in the initial issue.

Maybe you should try simplifying the dataset.

Sorry buddy, Hope it works for you. I am calling it a day.

Regards,

Pranit