DAX Calculate the Max for a Group with SUM

[AlexEnergee3]

Hello,

the follow query

evaluate 
SUMMARIZECOLUMNS(
    Machines[BillOfResources],
    Machines[Name],
    FeedbackDetails[Code],
    FeedbackDetails[description],
    FeedbackDetails[DescriptionLocal],
    --"Number", CALCULATE(DISTINCTCOUNT(Feedbacks201801[FeedbackID]),Filter(Dates,Dates[TimeStamp]>=Date(2018,02,02)),Filter(Dates,Dates[TimeStamp]<=Date(2018,02,28)),Filter(Machines,Machines[BillOfResources]="Mold1")),
    "TotalPeriod", CALCULATE(Sum(Feedbacks201801[Period]),Filter(Dates,Dates[TimeStamp]>=Date(2018,02,02)),Filter(Dates,Dates[TimeStamp]<=Date(2018,02,28)),Filter(Machines,Machines[BillOfResources]="Mold1"))
)
order by [totalperiod] desc

return the follow result

BillOfResources	Name	Code	Description	DescriptionLocal	TotalPeriod
Mold1	Mold1.DryEntry	52	Alarm description 52	Alarm local description 52	21
Mold1	Mold1.GreenCut	31	Alarm description 31	Alarm local description 31	20
Mold1	Mold1.ConveyorsExitDryer	114	Alarm description 114	Alarm local description 114	16
Mold1	Mold1.ConveyorsExitDryer	1	Alarm description 1	Alarm local description 1	15
Mold1	Mold1.Dry	28	Alarm description 28	Alarm local description 28	15
Mold1	Mold1.CutExit	18	Alarm description 18	Alarm local description 18	15
Mold1	Mold1.Lamgea	125	Alarm description 125	Alarm local description 125	15
Mold1	Mold1.CutExit	118	Alarm description 118	Alarm local description 118	15
Mold1	Mold1.Lamgea	60	Alarm description 60	Alarm local description 60	15
Mold1	Mold1.CutExit	15	Alarm description 15	Alarm local description 15	15
Mold1	Mold1.ConveyorsExitDryer	55	Alarm description 55	Alarm local description 55	15
Mold1	Mold1.CutExit	66	Alarm description 66	Alarm local description 66	15
Mold1	Mold1.Dry	8	Alarm description 8	Alarm local description 8	15
Mold1	Mold1.DryEntry	19	Alarm description 19	Alarm local description 19	15
Mold1	Mold1.Lamgea	77	Alarm description 77	Alarm local description 77	14

I need to obtain the Max Total Period column grouped by Name column

Can anyone help me?

Thanks!

[v-xjiin-msft]

Hi @AlexEnergee3,

In your scenario, you can using SUMMARIZECOLUMNS() function to create a new calculated table. Right?

Then to achieve your requirement, you can create a new measure in this new calculated table. The expression is like:

MAX Total Period =
CALCULATE ( MAX ( Table[TotalPeriod] ), ALLEXCEPT ( Table, Table[Name] ) )

Thanks,
Xi Jin.