Forum Discussion
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...
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.
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.
Thank you SabineOussi!!
It worked.
