Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
SkorpionAAM
Helper V
Helper V

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
mahoneypat
Employee
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





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

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


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

 

 

Still giving 18

pranit828
Community Champion
Community Champion

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





PBI_SuperUser_Rank@1x.png


Hope it resolves your issue? 
Did I answer your question? Mark my post as a solution!

Appreciate your Kudos, Press the thumbs up button!!
Linkedin Profile

This 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





PBI_SuperUser_Rank@1x.png


Hope it resolves your issue? 
Did I answer your question? Mark my post as a solution!

Appreciate your Kudos, Press the thumbs up button!!
Linkedin Profile

no Capture.PNG

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





PBI_SuperUser_Rank@1x.png


Hope it resolves your issue? 
Did I answer your question? Mark my post as a solution!

Appreciate your Kudos, Press the thumbs up button!!
Linkedin Profile

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

HI @SkorpionAAM 

 

Sure...

 

Regards,

Pranit





PBI_SuperUser_Rank@1x.png


Hope it resolves your issue? 
Did I answer your question? Mark my post as a solution!

Appreciate your Kudos, Press the thumbs up button!!
Linkedin Profile

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

Hi @SkorpionAAM 

 

What is the folder and the file name?

 

Regards,

Pranit





PBI_SuperUser_Rank@1x.png


Hope it resolves your issue? 
Did I answer your question? Mark my post as a solution!

Appreciate your Kudos, Press the thumbs up button!!
Linkedin Profile

File Nme is

 

Gas Station Need and Road coverage analysis V21

I uploazd as A zip file now u can download

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

 

 





PBI_SuperUser_Rank@1x.png


Hope it resolves your issue? 
Did I answer your question? Mark my post as a solution!

Appreciate your Kudos, Press the thumbs up button!!
Linkedin Profile

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.