Displaying multiple values

Anonymous — Fri, 03 Jul 2020 01:25:52 GMT

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

Re: Displaying multiple values

Anonymous — Fri, 03 Jul 2020 01:31:49 GMT

~~M001-HubTimeGroupInSeconds=SUM(PRDetailHistory[SEVERITYDECODE])~~

M001-HubTimeGroupInSeconds=SUM(PRDetailHistory[Duration])

topic Re: Displaying multiple values in DAX Commands and Tips

Displaying multiple values

Re: Displaying multiple values