Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |