Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)"})
)
Solved! Go to Solution.
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)"
}
)
Proud to be a Super User!
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)"
}
)
Proud to be a Super User!
You sir are a genius, thankyou it worked 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
79 | |
74 | |
56 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |