Forum Discussion

icbd's avatar
icbd
Helper I
4 years ago
Solved

Create top X table visual

Good morning all,   I am registering faults on a machine, where I have start time, end time and description of all faults. I am trying to get a table visual to only display the longest duration fau...
Need Help
  • BA_Pete's avatar
    BA_Pete
    4 years ago

    Hi icbd ,

     

    First create a measure to get your MAX duration:

    _maxDuration = MAX(yourTable[Duration])

     

    Then create a measure that picks out your [Fault Start] date where the duration is the MAX:

    _maxFaultStart = 
VAR __maxStart =
MAX(yourTable[Duration])
RETURN
CALCULATE(
    SELECTEDVALUE(yourTable[Fault Start]),
    yourTable[Duration] = __maxStart
)

     

    Put [Description], [_maxDuration], and [_maxFaultStart] into a table and it should do want you need.

     

    Pete

BA_Pete's avatar
BA_Pete
Super User
4 years ago

Hi icbd ,

 

Yes, it will return a single value (the maximum), but when you add context (by including [Description] in the table) it will be evaluated only over the [Description] group thus giving you the maximum values per [Description], as per your requirement: "I only want the max value per each description".

 

Pete

icbd's avatar
icbd
Helper I
4 years ago

Thank you, I was able to get this to work. Much appreciated.