Column with max value in all Rows

[Anonymous]

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

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]

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]

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

[Anonymous]

Thanks,

But´s now the problem is that, when i want to calculate the MAX-TOTAL...

[Zubair_Muhammad]

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))