Count all Orders regardless the Date Relationship

[joshua1990]

Hello everybody!

I need to calculate the number of orders with a specific status.

The order table has the following structure:

Order	Status	Date (key)	Item (key)
1	50	01.01.2019	A

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>

• Area A = 1000
• Area B = 1000

It should be something like

• Area A = 500
• Area B = 300
• Area C = 200

[amitchandak]

@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])

[kriscoupe · Accepted solution]

Hi @joshua1990,

Cant you do something like (assuming the table has one row per order)

CALCULATE(
    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

Kris