DAX Calculate the MAX of a MAX

[tabbey]

Hi there,

I am new to DAX and has spent days trying to figure this out. I need to find a MAX of MAX. 

The sample here shows the MAX sales by weekday. It is derived by using the MAX function, MAX(Sales). I need a second MAX column that shows the MAX of all weekday. Simply put, MAX of the first MAX(Sales), MAX(MAX(Sales)).

The Weekday is from DimDate table, which is referred by the FactSales Table.

I've tried all options i found online but with no luck. Any suggestion?

Weekday	MAX(Sales)	MAX(Max(sales))
Monday	1000	5000
Tuesday	200	5000
Wednesday	2500	5000
Thursday	3000	5000
Friday	1500	5000
Saturday	5000	5000
Sunday	2500	5000

Thanks,

TH

[Phil_Seamark · Accepted solution]

HI @tabbey

Please try this pattern in your calculated measure

Measure = 
VAR X = SUMMARIZE(ALL('DimDate'),'DimDate'[Weekday],"M",MAX('FactSales'[Sales]))
RETURN MAXX(x,[M])

[raksha_gangwal]

Finding Max of Max in Power BI - BY RAKSHA GANGWAL
Problem Statement: Hi, As I can understand your situation
We have a table as below:
MaterialNo.   MDno.  MD_Item.
ABC10            7                 10
ABC10            8                  3
ABC10            9                  4
PQR10            7                 10
PQR10            8                  3
XYZ10             9                  4

Expected Solution: In this Case, It should first take Max of MDno. based on Material No. and then take Max of MD_item. based on previous max MDno. Accordingly, the result being as follows:
MaterialNo.   MDno.  MD_Item
ABC10            9                  4
PQR10            8                  3
XYZ10             9                  4

Solution: We can create a summarize table using the dax code as shared below:

SELECTCOLUMNS (

    SUMMARIZE (

        FILTER (

            MaterialTransaction,

            MaterialTransaction[MDno] = CALCULATE (

                MAX ( MaterialTransaction[MDno] ),

                ALLEXCEPT ( MaterialTransaction, MaterialTransaction[MaterialNo] )

            )

        ),

        MaterialTransaction[MaterialNo],

        MaterialTransaction[MDno],

        "Max MDItemNo", MAX ( MaterialTransaction[MDItem] )

    ),

    "MaterialNo", MaterialTransaction[MaterialNo],

    "MDNo", [MDno],

    "MD_Item", [Max MDItemNo]

)

Note: Material Transaction is the name of Base Table here, you can add your table name or necessary column name and tweak the code. Give it a like if this solves your issues. Thanks 🙂

[tabbey]

OMG! You're my hero!! It worked!! Thank you Phil_Seamark.