Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Creating industry average

Hi! I would like to calculate an industry average of total visits. How do i do that?  I have to tables.  Table 1:  Customer name Industry name Customer 1 Industry 1 Customer 2 ...
Need Help
  • FarhanAhmed's avatar
    FarhanAhmed
    6 years ago

    Try by creating 2 measures. Make sure that Industry and Visits table are joined properly

    m_SUMVisits = SUM(Visits[Visits])
    m_Avg = AVERAGEX(VALUES(Industry[Customer name]),[m_SUMVisits])

     

FarhanAhmed's avatar
FarhanAhmed
Icon for Community Champion rankCommunity Champion
6 years ago

Try by creating 2 measures. Make sure that Industry and Visits table are joined properly

m_SUMVisits = SUM(Visits[Visits])
m_Avg = AVERAGEX(VALUES(Industry[Customer name]),[m_SUMVisits])

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi FarhanAhmed 

 

THANK YOU SO MUCH! I love this community! 😄 

It worked like a charm! 

For anyone in the future, my final two measures was named: 

Total visits = SUM('Sessions (SessionStats)'[Total sessions])
 
Visits average = AVERAGEX(VALUES(Customers[Customer name]),[Total visits])