Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |