Forum Discussion
How to get the average through different table
Hi,
I'm sorry for bothering but I really want to ask the question. What to do if I want to get the average score for the below attribute while ignoring the blank value. As I a begginer what I do to get the bar chart is I sum all the value for the attribute like this and make the average for the value like this in the image below. But when I doing it like this it does not ignore the blank value when I doing the average because all the CP is from the different table. What I should do gurus to make it ignore the blank value by filter it by region and month.
Example is like this. It still divide by 9 even other value is 0.
Thank you so much in advance for the help given.
7 Replies
Anonymous ,
Averagex(Values(Table[Customer]),[Sum of CP])
Hi amitchandak , I've try the method you give but it doesn't work as the table for customer is the combination of my sheet in the field. so when i try it it turn on error. because i dont have one table for all the customer value.
Anonymous , in Values you need to give group by or the not summarized column of visual and that should close by ) like customer
