Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
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.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |