Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Column with max value in all Rows

I need a dax function that populates all Rows of column Top1 with the Max Value of sales.

looking at the picture, i want 1423 in all rows.

 

 

 

  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi Anonymous,

     

    I guess the [sales] is a measure. Maybe you can try it like this:

    Measure 23 =
CALCULATE (
    MAXX (
        SUMMARIZE (
            Sales,
            Calender[Date].[Year],
            Calender[Date].[Month],
            "saless", SUM ( Sales[Quantity] )
        ),
        [saless]
    ),
    ALL ( Calender )
)

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards!

    Dale

5 Replies

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    8 years ago

    Hi Anonymous

     

    As a calculated column, you can use

    Top1=MAX(TableName[Sales])


    As a measure, you can use

     

    Top1=Calculate(MAX(TableName[Sales]),All(TableName))
  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi Anonymous,

     

    I guess the [sales] is a measure. Maybe you can try it like this:

    Measure 23 =
CALCULATE (
    MAXX (
        SUMMARIZE (
            Sales,
            Calender[Date].[Year],
            Calender[Date].[Month],
            "saless", SUM ( Sales[Quantity] )
        ),
        [saless]
    ),
    ALL ( Calender )
)

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards!

    Dale

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

       

      Hi,

       

      I have another problem:

      if i add another column "Nuts", Your measure23 don´t work for Nuts Context.

      Can you help me

       

      Best regards

       

       

       

       

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Microsoft Employee
        8 years ago

        Hi Anonymous,

         

        You can add another ALL() like this:

        Measure 23 =
CALCULATE (
    MAXX (
        SUMMARIZE (
            Sales,
            Calender[Date].[Year],
            Calender[Date].[Month],
            "saless", SUM ( Sales[Quantity] )
        ),
        [saless]
    ),
    ALL ( Calender ),
    ALL ( 'YourTable'[Nuts] )
)

        Best Regards!

        Dale