cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

Wrong 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 4as you can see left sde have 5 and right have 4

when i count sedment id its giving me 18when 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 14
Highlighted
Community Champion
Community Champion

Re: Wrong Value shoing on Measure

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


Hope it resolves your issue? Please consider accepting it as the solution to help the other members find it more quickly.


Appreciate your Kudos, Press the thumbs up button!!👍


Regards,
Pranit


Highlighted
Helper III
Helper III

Re: Wrong Value shoing on Measure

This Already in measure so i cant use Sum in Measure

Highlighted
Community Champion
Community Champion

Re: Wrong Value shoing on 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


Hope it resolves your issue? Please consider accepting it as the solution to help the other members find it more quickly.


Appreciate your Kudos, Press the thumbs up button!!👍


Regards,
Pranit


Highlighted
Helper III
Helper III

Re: Wrong Value shoing on Measure

no Capture.PNG

Highlighted
Community Champion
Community Champion

Re: Wrong Value shoing on Measure

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


Hope it resolves your issue? Please consider accepting it as the solution to help the other members find it more quickly.


Appreciate your Kudos, Press the thumbs up button!!👍


Regards,
Pranit


Highlighted
Super User VI
Super User VI

Re: Wrong Value shoing on Measure

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





Did I answer your question? Please mark my post as a solution! Kudos are also appreciated!

Proud to be a Super User!




Highlighted
Helper III
Helper III

Re: Wrong Value shoing on Measure

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

Highlighted
Helper III
Helper III

Re: Wrong Value shoing on Measure

SUMX(VALUES(Table[_50segment_id]), [Sum Covered])

 

 

Still giving 18

Highlighted
Community Champion
Community Champion

Re: Wrong Value shoing on Measure

HI @SkorpionAAM 

 

Sure...

 

Regards,

Pranit


Hope it resolves your issue? Please consider accepting it as the solution to help the other members find it more quickly.


Appreciate your Kudos, Press the thumbs up button!!👍


Regards,
Pranit


Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors