Need to calculate Max for each ID and summarize at ID level

[Sriku]

Hi,

Need help in find max for each ID and summarize it:

Regards,

Sriku

[mahoneypat]

Did you try just MAX(Table[Sales]) ?  That should work in this scenario, even with the Profit column slicer.

Pat

[Sriku]

Hi Pat, I am new and learning DAX, Can you please help in this

[amitchandak]

@Sriku ,

Create a measure

sumx(values(Table[ID]),Calculate( Max(Table[Sales])))

plot with ID in visual

[Sriku]

Thanks for prompt response: If there a profit column need to filter by 1 and find max 

Please help this

[v-yiruan-msft · Accepted solution]

Hi @Sriku ，

You can create a measure as below, please find the attachment for the details.

Max of Sales = 
VAR _tab =
    SUMMARIZE (
        'Table',
        'Table'[ID],
        "maxSales",
            CALCULATE (
                MAX ( 'Table'[Sales] ),
                FILTER (
                    'Table',
                    'Table'[ID] = SELECTEDVALUE ( 'Table'[ID] )
                        && 'Table'[Profit] = 1
                )
            )
    )
RETURN
    SUMX ( _tab, [maxSales] )

In addition, there are some good resources can help you learn DAX.

Good Source to Learn DAX

Use DAX in Power BI Desktop

How to learn DAX

DAX Guide

Best Regards