Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

measure showing different values in different visuals

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
 
Need Help

1 Reply

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    3 years ago

    Validate that the filters on both visuals are the same.