Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 average of TotalDuration and HoldDuration. When I apply the average, it shows the TotalDuration as 125 (i.e. 100+150/2) and HoldDuration as 50.
Actually, I need HoldDuration to display as 25. Can you anyone help me in solving this issue.
Incident
HoldActivity
Thanks
Rakesh
Solved! Go to Solution.
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.
What logic are you using to determine that the value should be 25?
Thanks,
Sam Lester (MSFT)
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |