Forum Discussion
admin_xlsior
Post Prodigy
Post ProdigyCalculate issue, something wrong with the context ?
Hi guys, Needs some light on of my measure. I have this table : And the last column is a measure which is like this : Count open critical orders = CALCULATE(
...
admin_xlsior , My Bad, change it like
Count open critical orders = CALCULATE(
DISTINCTCOUNTNOBLANK('Work orders'[Work order number]),
filter('Work orders','Work orders'[Critical] = "Yes" &&
NOT('Work orders'[Status] IN {"Closed", "Invoiced", "Finished", "Canceled"})
))
amitchandak
Super User
Super Useradmin_xlsior , Try like
Count open critical orders = CALCULATE(
DISTINCTCOUNTNOBLANK('Work orders'[Work order number]),
filter('Work orders','Work orders'[Critical] = "Yes",
NOT('Work orders'[Status] IN {"Closed", "Invoiced", "Finished", "Canceled"})
))
admin_xlsioroo but FILTER, can only contain 1 condition, is it?
And actually now I'm confuse why we need to use FILTER again, while CALCULATE is able to do filtering, it even support multiple condition, right ?