hi ALL
1. Bot Performance =
VAR A = CALCULATE(COUNT(DPNArchivedRequests[ReqStatus]),filter(DPNArchivedRequests,DPNArchivedRequests[ReqStatus] = "Bot Processed"))
VAR B = CALCULATE(COUNT(DPNArchivedRequests[ReqStatus]),DPNArchivedRequests[ReqStatus] IN { "Bot Processed","Bot Partially Processed","Bot Failed","Manually processed"})
return
divide(A,B)
2. Bot Utilization =
VAR A = CALCULATE(COUNT(DPNArchivedRequests[ReqStatus]),DPNArchivedRequests[ReqStatus] IN { "Bot Processed","Bot Partially Processed","Bot Failed","Bot Processing"})
VAR B = CALCULATE(COUNT(DPNArchivedRequests[ReqStatus]),DPNArchivedRequests[ReqStatus] IN { "Bot Processed","Bot Partially Processed","Bot Failed","Bot Processing","Manually processed"})
return
divide(A,B)
case 1
i used the 1st measure in card visual and 1st and 2nd measure line chart by adding date . it was showing the different values.
case 2
i used 1st and 2nd measure line chart by adding date and i add 1 measure in table . it was showing the different values.
please help
Regards
Dilip