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])