Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 ...
Data Protection
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    4 years ago

    I already found the solution for this.

    Average for Customer Promise =
    VAR Count_ =
    INT ( Table 1<> BLANK () )
    + INT ( Table 2 <> BLANK () )
    + INT ( Table 3 <> BLANK () )
     
    RETURN
    DIVIDE ( Table 1+ Table 2 + Table 3, Count_ )
amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous ,

Averagex(Values(Table[Customer]),[Sum of CP])

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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. 

     

     

    • amitchandak's avatar
      amitchandak
      Super User
      4 years ago

      Anonymous , in Values you need to give group by or the not summarized column of visual and that should close by )  like customer

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        I try to group the measures into one table like the image below but when I insert the the formula for the averagex it still error.

        it stated that the group does not have the column why it happen like that?