Forum Discussion

hanssonnor's avatar
hanssonnor
Frequent Visitor
5 years ago
Solved

Problem MAXX function with string

Hi,   I am currently working on a measure using the following table:   Number Item Reason Code Status Center 60607788 abc 0B 10 G1A30 60607788 abc 0B 20 G1G30 60607788 ab...
  • hanssonnor's avatar
    hanssonnor
    5 years ago

    Hi Amit,

     

    thanks a lot,  it works 🙂

     

    Best regards

    Arne

     

colacan's avatar
colacan
Resolver II
5 years ago

MAXCC =
VAR maxStatus =
    CALCULATE (
        MAX ( 'Work Order Time Transactions'[Status] ),
        ALLEXCEPT (
            'Work Order Time Transactions',
            'Work Order Time Transactions'[Item]
        ),
        'Work Order Time Transactions'[Reason Code] = "0B"
    )
RETURN
    CALCULATE (
        SELECTEDVALUE ( 'Work Order Time Transactions'[Center] ),
        'Work Order Time Transactions'[Status] = maxStatus
    )

  • hanssonnor's avatar
    hanssonnor
    Frequent Visitor
    5 years ago

    Hi Colacan,

     

    thanks for your approach. I had to modify it though, with the Allexcept it did not work. However once I removed that filter it showed the same results.

     

    Best regards

    Hansson

    • colacan's avatar
      colacan
      Resolver II
      5 years ago

      hanssonnor  Hi Hanssonnor, I have noticed that extracting highest or lowest recode within categories is quite tipical problem which lots of people are facing. And Allexcept function is quite useful for those problems.

      Cheers!