Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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>
It should be something like
Solved! Go to 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
@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])
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |