Forum Discussion

webbj's avatar
webbj
Icon for Helper I rankHelper I
4 years ago
Solved

Multiple Filter Average Calculation

Hi all,    I am trying to calculate the average based off of multiple filters, beneath are some examples of what I have been trying however when displaying on 'card' it'll display as (blank). Could...
Need Help
  • DataInsights's avatar
    DataInsights
    4 years ago

    webbj,

     

    Try this measure:

     

    Measure =
CALCULATE (
    AVERAGE ( Combined[Response Time (Days)] ),
    Combined[Type]
        IN {
        "CT - Change Request (10)",
        "CT - General Support (5)",
        "CT - New Implementation (10)",
        "CT - Technical Issue/Fault (10)"
    }
)
DataInsights's avatar
DataInsights
Icon for Super User rankSuper User
4 years ago

webbj,

 

Try this measure:

 

Measure =
CALCULATE (
    AVERAGE ( Combined[Response Time (Days)] ),
    Combined[Type]
        IN {
        "CT - Change Request (10)",
        "CT - General Support (5)",
        "CT - New Implementation (10)",
        "CT - Technical Issue/Fault (10)"
    }
)
webbj's avatar
webbj
Icon for Helper I rankHelper I
4 years ago

You sir are a genius, thankyou it worked 🙂