Forum Discussion
AdministratorSUMMING MAXIMUM VALUES
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.
Resolver III don't know how your data is structured, however this is a perfect case to use SUMX:
CALCULATE(
SUMX(
SELECTCOLUMNS(
MARKINGS,
MARKINGS[AREA],
MARKINGS[FECHA],
MARKINGS[ZONIA],
"V_Calc",
MAX(MO)
),
V_Calc
),
FILTER(
MARKINGS,
AND(
DIALS[DATE] = SELECTEDVALUE (MARKINGS[DATE]),
MARKINGS[AREA] = SELECTEDVALUE ( MARKINGS[AREA] )
)
)
)
This DAX will find the MAX value of MO for the selected columns, then SUM that value. This may not work 100% in your case, however I'd suggest investigating the SUMX function and the SELECTCOLUMS function to help solve this problem.
AdministratorThank you for the support. The formula didn't work for me but I'm sharing the files so you can help me please
https://docs.google.com/spreadsheets/d/1VyOXw5ckuLPMej0LiAwuKJdrj0EEA7EH/edit?usp=sharing&ouid=118176023069486866424&rtpof=true&sd=true
https://drive.google.com/file/d/1z0a8LRccPH7mBE4Cq_FjOZNcIzbjX6sq/view?usp=sharing
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.