cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Partisan
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:

OrderStatusDate (key)Item (key)
15001.01.2019A

 

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

View solution in original post

2 REPLIES 2
Highlighted
Resolver IV
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

View solution in original post

Highlighted
Super User IX
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])



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors