Percentage issue

[Ish_Al]

Hi!

I am new to the community. I am trying to do an analysis of appointments. I have data on total number of appointments for each day of the month and total appointments booked and unbooked for the month by and a % unbooked (unbooked/total appt) by agent.Percentage error 

In my dashboard,  I have a bar chart that shows unbooked %  by agent. However, the percentage shown for the measure is not correct as in when I manually divide unbooked by total appt, I get a different number. See image.  

It is the same issue when I create a KPI about % unbooked with formula Avg([%NeverBooked]). 

I created a master measure [unbooked/total appointments] separately for my pivot chart and that resolved the issue with showing the correct percentages. However, when I use the master measure in the bar chart or the KPI, it turns blank.  

Can anyone help give some guidance on what I am doing wrong? 

[Mauritz_SA · Accepted solution]

Hi there

I think you are trying to get the average of a percentage which does not work as that assumes that every percentage has the same weighting. For example, say you have 10 possible appointments this month and 20 last month. You fill 5 spots for both months. Your [%NeverBooked] for this month is 50% (5/10) and for last month it is 75% (15/20), but in total it is 66% ((5+15)/(10+20)) and not 62.5% which is the average of the two averages.

Can you not just use Sum(unbooked)/Sum(total appointments) as your measure? Or do you actually want to see the average unbooked per month? Maybe share a sample table with your inputs and another with your expected results.

Regards,

Mauritz

[Ish_Al]

Thank you Mauritz! That did do the trick. I didn't realize that even though I picked %Neverbooked measure, I can define measure function as sum(unbooked)/sum(total appts), which are different measures, for my KPI or Bar Chart. 

Best,

Ish