I need to calculate the number of orders with a specific status.
The order table has the following structure:
This table is linked to the calendar table and to the item master (Item > Area).
Now I need the calculate the number of orders that have the status "50" regardless of the date.
The following function is not working:
Status = COUNTX(FILTER(ALL(Orders),Orders[Status]=16),Orders[Order])
I get the correct number of work orders but this result is displayed at every area in the item master>
It should be something like
Go to Solution.
Cant you do something like (assuming the table has one row per order)
COUNTROWS( Orders ),
ALL( Calendar Table ),
Orders[Staus] = 50
Not sure if you wanted orders status to be 50 or 16 from your question but just replace accordingly.
Hope it helps
View solution in original post
@joshua1990 , Try one of the two
Status = COUNTX(FILTER((Orders),Orders[Status]=16),Orders[Order])Status = COUNTX(FILTER(allselected(Orders),Orders[Status]=16),Orders[Order])
Proud to be a Super User!
Check out a full recap of the month!
Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.