Forum Discussion

floppysock's avatar
floppysock
Frequent Visitor
3 years ago
Solved

Average Issues

Hi all - I'm struggling to figure out how to get the averages working correctly for a data set that already has averages in.    The data set - e.g. row 1 is saying Agent 1 completed 3 tasks and the...
Need Help
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi floppysock 

    try to plot a table visual wit the Team Name column and a measure like:

    Avg = 
DIVIDE(
    SUMX(
        TableName,
        TableName[Volume Completed]*TableName[AVG Hours to Complete]
    ),
    SUM(TableName[Volume Completed])
)

     

    it worked like:

     

FreemanZ's avatar
FreemanZ
Super User
3 years ago

hi floppysock 

try to plot a table visual wit the Team Name column and a measure like:

Avg = 
DIVIDE(
    SUMX(
        TableName,
        TableName[Volume Completed]*TableName[AVG Hours to Complete]
    ),
    SUM(TableName[Volume Completed])
)

 

it worked like:

 

floppysock's avatar
floppysock
Frequent Visitor
3 years ago

This is exactly what I needed - thanks so much. 

I think I need to go read up and explore the SUMX etc functions as the key lies there.