Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Displaying multiple values

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

 

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

     

    M001-HubTimeGroupInSeconds=SUM(PRDetailHistory[SEVERITYDECODE])

     

    M001-HubTimeGroupInSeconds=SUM(PRDetailHistory[Duration])