Stuck with more than 2 arguements with OR & AND

[Anonymous]

Hi All,

SOS, need an urgent help over the countrows formula.

Situation:

I have a operation statuses where consist of "New", "Pending", "In Progress", "Assigned", "Resolved" and "Closed"

End of day, I need to show the summary of WIP volume, consists of "New", "Pending", "In Progress", "Assigned" statues. I managed to do with 2 arguements, with sample formula:-

Total Resolved & Closed Volume = COUNTROWS(FILTER('KPI',OR('KPI'[Status]="Closed",'KPI'[Status]="Resolved")))

However, failed to do the magic for 4 statues mentioned above. I tried browsing through the other threads, and understand I should do nesting, but very new to PowerBI, and hoping some of you can provide some guidance on how nesting works.

Thank you in advance.

Bobby

[MattAllington · Accepted solution]

There are a few options
 
1. worst is to nest the or statements.  Or(x,or(y,z))
2. use inline syntax. X || Y || Z (|| is a double pipe which is above the enter key (shift backslash)).  Use && for and
 
I think this will work too
 
calculate(countrows(table),column=x || column=y || column=z)
  
Also with And, you can use this syntax
calculate(countrows(table),column=x,column =y,column=z)

[Anonymous]

thank you. || works!!