Forum Discussion
Percentage calculation
Hi,
I have half hourly intervalwise raw data available on which when I use pivot in excel and get #DIV error, I replace those with '0' which make my pivot look presentable. However, when I use the same data in power BI and add a new column as abandoned % in data view where i use total abandoned/total calls offered and add that formulated column in visuals, I get the error as "NaN". Now, I am not able to replace this with '0'. My question is, how do I do that?
Looking for instant help..thanks
12 Replies
Hi,
I have a table with complete month data and it has some columns like total calls offered, answered, abandoned etc. Now, if I am trying to add a column like aban% where I am dividing abandoned by offered and trying to reflect it in my chart I am not getting the result which I am expecting, like it is giving me infinity error for some dates under the aban% column. Now, my main concern is how do I get rid of it. I know I can do this in excel but not sure how to do it in power bi. So, I am really looking for some help here...
Thanks sean for your help. But, still not able to get the perfect result. Actually, I am calculating SL%, Aban% and Ans% based on the raw data. However, the result varies big time in power bi as compared to excel. For eg. SL% for 1st day of the month in excel comes to 89.3% and comes as 97.44% in power bi. Not sure, what to do next??
Hi jeevan_mehra,
Can you please share some detail content of your issue? It is hard to reproduce your issue from your description.
Regards,
Xiaoxin Sheng
Hi jeevan_mehra,
Can you provide the measure formulas which you mentioned? I'm not very clear these formula.
Regards,
Xiaoxin Sheng
Hi,
For calculating SL% I have used measure - DIVIDE (calls answered in 20 sec, net calls offered(Total calls offered-calls aban in 10 sec))
For calculating Aban% I have used measure - DIVIDE (total calls abandoned, total calls offered)
