Forum Discussion

Greg888's avatar
Greg888
Helper I
4 years ago
Solved

Getting a max step from a group

Hi All

 

I have what I think could be a fairly simply problem to solve but I have been going around and around in circles to try to get the answer and now I'm just stuck or not understanding why this would not work.

I have a table below and I want to identify with a 1 which step is the max step in the GROUP, the unique or grouped item is the DocNumber and the group has several steps, all I am trying to do is to add an indicator to say the highest step number I have tried some what I thought would work calculation but it always ends up the same way 😞






Need Help
  • CNENFRNL's avatar
    CNENFRNL
    4 years ago
    MaxStepNo =
MAXX(
    FILTER(
        'Document Steps',
        'Document Steps'[DocNumber] = EARLIER( 'Document Steps'[DocNumber] )
    ),
    'Document Steps'[StepNo]
)

6 Replies

  • SpartaBI's avatar
    SpartaBI
    Community Champion
    4 years ago

    Greg888 

     

     

    MaxStepNo = 
VAR _current_doc = 'Document Steps'[DocNumber]
RETURN
CALCULATE(
    MAX('Document Steps'[StepNo]),
    REMOVEFILTERS('Document Steps'),
    'Document Steps'[DocNumber] = _current_doc
)

     

     

     

    In case it answered your question, please accept it as a solution to help the other members find it more quickly. Appreciate Your Kudos 💪
    Showcase Report – Contoso By SpartaBI 
    Website Linkedin Facebook 
    This is SpartaBI!
    • Greg888's avatar
      Greg888
      Helper I
      4 years ago

      Sadly gives me the exact same result of  my original query

      • SpartaBI's avatar
        SpartaBI
        Community Champion
        4 years ago

        Greg888 Very strange! Did you change something in what I sent you? I see in your measure you want to return 1 or 0. Did you wrap my measure with additional logic for that?

  • CNENFRNL's avatar
    CNENFRNL
    Community Champion
    4 years ago
    MaxStepNo =
MAXX(
    FILTER(
        'Document Steps',
        'Document Steps'[DocNumber] = EARLIER( 'Document Steps'[DocNumber] )
    ),
    'Document Steps'[StepNo]
)
    • Greg888's avatar
      Greg888
      Helper I
      4 years ago

      ok thank you for this so that produced the last step correctly as a number in the column

      I then did a 

      IF(Document Steps [MaxStep] = DocumentSteps[StepNo],1,0)

      Which has given me a column I can use going foward. Thanks for all your help