Forum Discussion

mumair's avatar
mumair
Icon for Helper I rankHelper I
9 years ago
Solved

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 ...
Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    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.



    Thanks,
    Angelia