Forum Discussion

admin_xlsior's avatar
admin_xlsior
Post Prodigy
5 years ago
Solved

Calculate 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( ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    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's avatar
amitchandak
Super User
5 years ago

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

  • admin_xlsior's avatar
    admin_xlsior
    Post Prodigy
    5 years ago

    Hi amitchandak 

     

    ahh yeah.. I'm about to reply the same ğŸ˜€

    I'm using AND function though, but it is the same idea. 

     

    Alhtough I'm still not too convince why I need to use FILTER, I thought CALCULATE will do the same.

     

    Thanks amitchandak