Forum Discussion

30rakesh's avatar
30rakesh
Regular Visitor
10 years ago
Solved

Average calculation on data between two tables

Hi,   I have two tables. One is 'Incident' and the second is 'HoldActivity' (and relation between these two tables is 'IncId' as shown below).  I need to display a visual which should show the aver...
Need Help
  • SabineOussi's avatar
    SabineOussi
    10 years ago

    You need to add something like this

     

    DIVIDE(
HoldActivity[HoldDuration],
DISTINCTCOUNT(Incident[IncId])
)

    if you are calculating the average of HoldDuration based on the number of incidents in table Incident.

     

     

     

SamLester's avatar
SamLester
Microsoft Employee
10 years ago

What logic are you using to determine that the value should be 25?

 

Thanks,
Sam Lester (MSFT)