Displaying multiple values

[Anonymous]

Hi,

Query fetching data from 2 tables which has 1-Many relationship and displaying on Matrix Visual.

TicketNumber is commom fields between the two tables(1-Many relationship).

DAX function :

M001-HubTimeGroupInSeconds=SUM(PRDetailHistory[SEVERITYDECODE])

M005-SLAStatus =
VAR Restoration=[M001-HubTimeGroupInSeconds]/60
VAR Critical=180
VAR High=300
VAR Medium=10080
return
if(HASONEVALUE(PRDetailHistory[SEVERITYDECODE]),
SWITCH(TRUE(),
AND(VALUES(PRDetailHistory[SEVERITYDECODE])="Critical",Restoration<=Critical),"IN",
AND(VALUES(PRDetailHistory[SEVERITYDECODE])="Critical",Restoration>Critical),"OUT",
AND(VALUES(PRDetailHistory[SEVERITYDECODE])="High",Restoration<=High),"IN",
AND(VALUES(PRDetailHistory[SEVERITYDECODE])="High",Restoration>High),"OUT"
)
)

Thanks.

Best Regards

[Anonymous]

M001-HubTimeGroupInSeconds=SUM(PRDetailHistory[SEVERITYDECODE])

M001-HubTimeGroupInSeconds=SUM(PRDetailHistory[Duration])