Calculate scores with Weights when Records are under same ID (Weights base on the column)

[SCQuestion]

I'm having a set of data need to calculate the 'weighted score'

The current records are created by events. When the system think they are cotinuous (Same start ime and same end time), the events are sharing same IDs. The events can be the same or different. Same could be because it is continuous. Different could be another issue happened at the same time period.

There are 24 types of events but we are only taking 8 types to analysis the KPI. I am filtering out the 16 types of events in all page.

Collision Monitor and Collision alert formed 'Collision' Event Classification.

While I'm using the event per hours, in the measure. It's too complex for me to follow Solved: Calculate scores with Weights - Microsoft Fabric Community

Events Per Hour = DIVIDE(COUNTA(EventDetails[ID])

--Divide to (count of events) by (Sum once only Duration for each trip)

,SUMX(SUMMARIZE(EventDetails,EventDetails[ID],EventDetails[Duration]),[Duration]))

Would anyone help me out? I want to get the total weighted score and average weighted score.

Sample weighting and data:

Event Classification	Weight
Left alert	0.3
Speeding	0.3
Right alert	0.1
Top alert	0.2
Bottom alert	0.05
Collision	0.05

ID	Duration	StartDate	EndDate	EventDate	Event
AHDE6786-gfvhgj768	1.444446	9/09/2022 14:42	9/09/2022 15:42	9/09/2022 15:20	Left alert
AHDE6786-gfvhgj768	1.444446	9/09/2022 14:42	9/09/2022 15:42	9/09/2022 15:20	Speeding
AHDE6786-gfvhgj768	1.444446	9/09/2022 14:42	9/09/2022 15:42	9/09/2022 15:21	Left alert
AHDE6786-gfvhgj768	1.444446	9/09/2022 14:42	9/09/2022 15:42	9/09/2022 15:22	Left alert
AHDE6786-gfvhgj768	1.444446	9/09/2022 14:42	9/09/2022 15:42	9/09/2022 15:23	Left alert
AHDE6786-gfvhgj768	1.444446	9/09/2022 14:42	9/09/2022 15:42	9/09/2022 15:24	Left alert
BBDE6786-gfvhgj768	1	9/09/2022 14:42	9/09/2022 15:42	9/09/2022 15:23	Left alert
BBDE6786-gfvhgj768	1	9/09/2022 14:42	9/09/2022 15:42	9/09/2022 15:24	Speeding
QQQDE6786-gfvhgj768	1.444446	9/09/2022 14:42	9/09/2022 15:42	9/09/2022 15:24	Right alert
YUUE6786-gfvhgj768	1	9/09/2022 14:42	9/09/2022 15:42	9/09/2022 15:23	Top alert
YUUE6786-gfvhgj768	1	9/09/2022 14:42	9/09/2022 15:42	9/09/2022 15:24	Bottom alert
YUUE6786-gfvhgj768	1	9/09/2022 14:42	9/09/2022 15:42	9/09/2022 15:24	Collision Monitor
YUUE6786-gfvhgj768	1	9/09/2022 14:42	9/09/2022 15:42	9/09/2022 15:24	Lane alert
YUUE6786-gfvhgj768	1	9/09/2022 14:42	9/09/2022 15:42	9/09/2022 15:24	Collision alert
YUUE6786-gfvhgj768	1	9/09/2022 14:42	9/09/2022 15:42	9/09/2022 15:24	Bottom alert

[wdx223_Daniel]

create one to many relationship from [event classification] to [event]

SUMX(SUMMARIZE(EventDetails,EventDetails[ID],EventDetails[Duration],EventDetails[Event]),[Duration]*RELATED(dimTable[Weight])))

[SCQuestion]

It keeps showing 'The syntax for 'dimTable' is incorrect' I matched the table name to my table name already.