Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
1 year ago
Solved

SUMMING MAXIMUM VALUES

Hello community, I need help with a report. I have a table where I want to add maximum values from a table, but instead of adding the values it results in the maximum value of what I'm filtering....
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Syndicate_Admin , hello Alex_Sawdo, thank you for your prompt reply!

     

    Please verify the following measure:

    MO = SUMX(
    SUMMARIZE(
        MARCACIONES,
        MARCACIONES[AREA],
        MARCACIONES[FECHA],
        "MaxPlanned", MAX(MARCACIONES[MO])
    ),
    [MaxPlanned]
)

    Result for your reference:

    Best regards,

    Joyce

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Syndicate_Admin , hello Alex_Sawdo, thank you for your prompt reply!

 

Please verify the following measure:

MO = SUMX(
    SUMMARIZE(
        MARCACIONES,
        MARCACIONES[AREA],
        MARCACIONES[FECHA],
        "MaxPlanned", MAX(MARCACIONES[MO])
    ),
    [MaxPlanned]
)

Result for your reference:

Best regards,

Joyce

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.