cancel
Showing results for
Did you mean:
Highlighted
Post Partisan

## Count all Orders regardless the Date Relationship

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Resolver IV

## Re: Count all Orders regardless the Date Relationship

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

2 REPLIES 2
Highlighted
Resolver IV

## Re: Count all Orders regardless the Date Relationship

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

Highlighted
Super User IX

## Re: Count all Orders regardless the Date Relationship

@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!