Get the latest & most repeated Unit Prices

[shareezsaleem]

Hi All, I am looking to extract latest value and most repeated value (if tie get max).

Item UOM Unit Price Order Date
Item1 EA 95.00 25-Jan-22
Item1 Carton 1,800.00 24-Feb-22
Item1 EA 95.00 19-Feb-22
Item1 EA 80.00 1-Mar-22

Result should be like this:

Item UOM Latest Unit Price Most Repeated
Item1 EA 80 95

Looking for dax meaure not calculated column measure.

[ddpl · Accepted solution]

@shareezsaleem try by creating below Measures

UOM  = var T1 = SUMMARIZE('Table','Table'[UOM],"Count",COUNTROWS('Table'))
       var T2 = MAXX(T1,[Count])
     return
       MAXX( T1, IF([Count] = T2,'Table'[UOM])) 

Latest Unit Price = var _M = MAXX('Table','Table'[Order Date])
                       return
                            CALCULATE(MAX('Table'[Unit Price]),'Table'[Order Date] = _M)

Most Repeated = var T1 = SUMMARIZE('Table','Table'[Unit Price],"Count",COUNTROWS('Table'))
                var T2 = MAXX(T1,[Count])
             return
                MAXX( T1, IF([Count] = T2,'Table'[Unit Price]))