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
mumair
Helper I
Helper I

How to Segment Data

So let's say I have 40 rows of data. Each row has one location, and there are 5 total possibilities. There is also a time to complete a task associated with each row. How can I show the average time to complete the task segmented by location?

1 ACCEPTED SOLUTION

Hi @mumair,

Please create measure using the formula below.

Average = AVERAGEX( DISTINCT(SELECTCOLUMNS(Table2,"Train",Table2[Train],"Location",Table2[Location],"Time",Table2[Time to Complete Inspection])),[Time])


Create a table visual to display the result.

1.PNG

Thanks,
Angelia

View solution in original post

4 REPLIES 4
mumair
Helper I
Helper I

Actually I have another complication. Say my data looks like this:

 

Shipment | Train | Location | Time to Complete Inspection

Order 1 | Train A | New York | 60

Order 2 | Train A | New York | 60

Order 3 | Train B | New York | 30

Order 4 | Train C | Chicago | 45

Order 5 | Train C | Chicago | 45

 

I want to know the average time to complete inspection per location. The time to complete inspection is related to the train, and not the shipment. Right now my calculations say it takes an average of 50 minutes to complete inspections at New York. This is incorrect. It should say it takes an average of 45 minutes to complete an inspection. This is because there are only 2 inspections at New York, Train A and Train B, not 3. How do I fix this?

Hi @mumair,

Please create measure using the formula below.

Average = AVERAGEX( DISTINCT(SELECTCOLUMNS(Table2,"Train",Table2[Train],"Location",Table2[Location],"Time",Table2[Time to Complete Inspection])),[Time])


Create a table visual to display the result.

1.PNG

Thanks,
Angelia

@mumair Can you post your dax code and put a screen shot of your visual?





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




vanessafvg
Super User
Super User

try the quick measures until you get the  hang of it

 

@mumair

 

https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-quick-measures/

 





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




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.