Forum Discussion

webbj's avatar
webbj
Helper 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 someone suggest where I am going wrong or any more ideas? Any help would be appreciated, thankyou!

 

Measure = AVERAGEX(FILTER('Combined','Combined'[Type]={"CT - Change Request (10)", "CT - General Support (5)", "CT - New Implementation (10)", "CT - Technical Issue/Fault (10)"}),'Combined'[Response Time (Days)])

Measure = CALCULATE(AVERAGEX(FILTER('Combined','Combined'[Type]={"CT - Change Request (10)", "CT - General Support (5)", "CT - New Implementation (10)", "CT - Technical Issue/Fault (10)"}),'Combined'[Response Time (Days)]))

Measure = CALCULATE(
    AVERAGE(Combined[Response Time (Days)]),
	FILTER(Combined, Combined[Type] = "CT - Change Request (10)"),
        FILTER(Combined, Combined[Type] = "CT - General Support (5)"),
        FILTER(Combined, Combined[Type] = "CT - New Implementation (10)"),
        FILTER(Combined, Combined[Type] = "CT - Technical Issue/Fault (10)")
)

Measure = CALCULATE(
    AVERAGE(Combined[Response Time (Days)]),
    FILTER('Combined','Combined'[Type]={"CT - Change Request (10)", "CT - General 
    Support (5)", "CT - New Implementation (10)", "CT - Technical Issue/Fault (10)"})
)

 

  • 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)"
        }
    )

2 Replies

  • 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
      Helper I

      You sir are a genius, thankyou it worked 🙂