Total of MAX values in a Table

[DorisCMoore]

Hello,

I'm having a table showing Max values of an attribute.

The Total row in this table shows the Max value in the table instead of the Sum of all the Max values.

Whether I use "Remaining Work" which is a column in my Data Model inserted as Maximum

or "Workload" which is a Measure (Workload = MAX(AllWorkItems[Remaining Work])))

doesn't change anything.

What should I change to have the Total be a Total and not the Max possible value in my Table?

Thank you,

Doris

[danextian]

hI @DorisCMoore ,

Try this:

= SUMX( Values ('table'[Column] ), MAX ('table'[Remaining Work] ) )

Replace 'table'[Column] with the first colum in your visual.

[mona_minchi]

Hi, 

Max of Remaining Work =

SUMX(

    ADDCOLUMNS(

        SUMMARIZE(AllWorkItems,AllWorkItems[Remaining Work]

        ),

        "Workload",

            CALCULATE(MAX(AllWorkItems[Remaining Work]))

    ),

    [Workload]

)

For the solution please refer to:
Solved: Calculate sum of the max values (show in rows) in ... - Microsoft Fabric Community

[MAwwad]

The reason why the total row in your table is showing the maximum value instead of the sum of all maximum values is because the "Total" row is not taking into account the aggregation performed in the "MAX" function.

To solve this issue, you can create a new measure that calculates the maximum value across all rows in the table, and then sum that new measure in the total row.

Here's an example measure that you can use:

MaxValue = MAX(AllWorkItems[Remaining Work])

[DorisCMoore]

Thank you @MAwwad for your answer.

But I'm afraid I'm missing something here.

The measure you propose is the one I already created:

Workload = MAX(AllWorkItems[Remaining Work]))

When I use it, the result is the same and there is no Sum option in that case