Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Group by order

I have a table looking like this: 

I would like to group all the orders and then have the max of precision per order.

Which mean I will get a report like this:

How would you write such a measure?

Thanks

Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    You really do not need a measure for this, just create a table visualization and then use the default Max aggregation on your precition column. So ordre and precition in the table visualization. 

  • v-alq-msft's avatar
    v-alq-msft
    6 years ago

    Hi, Anonymous 

     

    Based on my research, you may create a measure as below.

     

    Sum of Max = 
SUMX(
    ADDCOLUMNS(
        SUMMARIZE(
            'Table',
            'Table'[order]
        ),
        "Max",
        CALCULATE(
            MAX('Table'[precition]),
            FILTER(
                ALL('Table'),
                'Table'[order] = EARLIER('Table'[order])
            )
        )
    
    ),
    [Max]
)

     

     

    Result:

     

    You can also create a calculated table as below

    NewTable = 
ADDCOLUMNS(
        SUMMARIZE(
            'Table',
            'Table'[order]
        ),
        "Max",
        CALCULATE(
            MAX('Table'[precition]),
            FILTER(
                ALL('Table'),
                'Table'[order] = EARLIER('Table'[order])
            )
        )
    
)

     

    Result:

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

4 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

    You really do not need a measure for this, just create a table visualization and then use the default Max aggregation on your precition column. So ordre and precition in the table visualization. 

  • v-alq-msft's avatar
    v-alq-msft
    Community Support
    6 years ago

    Hi, Anonymous 

     

    Based on my research, you may create a measure as below.

     

    Sum of Max = 
SUMX(
    ADDCOLUMNS(
        SUMMARIZE(
            'Table',
            'Table'[order]
        ),
        "Max",
        CALCULATE(
            MAX('Table'[precition]),
            FILTER(
                ALL('Table'),
                'Table'[order] = EARLIER('Table'[order])
            )
        )
    
    ),
    [Max]
)

     

     

    Result:

     

    You can also create a calculated table as below

    NewTable = 
ADDCOLUMNS(
        SUMMARIZE(
            'Table',
            'Table'[order]
        ),
        "Max",
        CALCULATE(
            MAX('Table'[precition]),
            FILTER(
                ALL('Table'),
                'Table'[order] = EARLIER('Table'[order])
            )
        )
    
)

     

    Result:

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

  • AilleryO's avatar
    AilleryO
    Memorable Member
    6 years ago

    Hi Anonymous ,

     

    Just using a measure like :

    BiggestPrecition =MAX(Precition)

    and then build a table with :

    ordre and the BiggestPrecition you just created.

    Should give you required results,

     

    Let us know and click on Accept as solution if it works.

     

    Have a nice day

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      You are absolutely correct.

      I forgot to mention if they want to remove the order from the table and look at week instead. Then I don't want the max of the week but a sum of all the max of each order.

      Hope this make sense