Sum of max with filters on max col

[antoinersw]

Hello, these are the data I work with :

In the third column, _heures projete signes, I have the sum of the max values

The new col (is a the target measure i designed on paint) sub totals should be the multiplication of

• the max _heures projete signes by the Duree presta value on the same row. Hence 104*10  = 1040

the grand total should be the sum of the max value for client A and B

Please advise the right DAX for that result 🙂

regards

[Anonymous · Accepted solution]

Hi @antoinersw,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

In addition, you can also try to use the following measure formula if it helps:

formula =
VAR summary =
    ADDCOLUMNS (
        SUMMARIZE (
            'Table',
            'Table'[Client],
            "maxSignes",
                CALCULATE (
                    MAX ( 'Table'[heures projete signes] ),
                    ALLSELECTED ( 'Table' ),
                    VALUES ( 'Table'[Client] )
                )
        ),
        "maxPresta",
            CALCULATE (
                MAX ( 'Table'[Duree presta] ),
                FILTER (
                    ALLSELECTED ( 'Table' ),
                    'Table'[heures projete signes] = [maxSignes]
                        && 'Table'[Client] = [Client]
                )
            )
    )
RETURN
    SUMX ( summary, [maxSignes] * [maxPresta] )

Regards,

Xiaoxin Sheng

[antoinersw]

Hello, is the calculus not clear enough ?