Group by order

[Anonymous]

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

[Greg_Deckler · Accepted solution]

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 · Accepted solution]

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

[Greg_Deckler · Accepted solution]

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. 

[AilleryO]

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]

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