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.
So thanks to @DataInsights I've been using the following to calculate the average based on mulitple filters from a single column in a table. However i'm now trying to figure out how to find calculate the average based on two conditions from two columns in the same table shown in second code segment.
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)"
}
)
Here is an example of what I've tried, I've tried others as well however it either displays 'blank' or the code errors.
Measure =
CALCULATE (
AVERAGE ( 'CT Combined Extracts'[Response Time (Days)] ),
'CT Combined Extracts'[Type]
IN {
"CT - Technical Issue/Fault (10)"
},
'CT Combined Extracts'[Service]
IN {
"CT - Case Access"
}
)
Any help would be much appreciated.
Solved! Go to Solution.
Hi @webbj
It should work. What error codes are you getting. Note that this is an "AND" condition between the two conditions so double check the spelling and make sure the two conditions actually intersect.
Hi @webbj
It should work. What error codes are you getting. Note that this is an "AND" condition between the two conditions so double check the spelling and make sure the two conditions actually intersect.
oops it you were right - there was a double space in the data extract and I had only put one space in. Thankyou!
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |