The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hey community!
I have a table like this:
Order | Date | State 1 | State 2 | Code | Quantity |
559955 | 01.02.2020 | 100 | 1 | X | 500 |
559955 | 02.02.2020 | 250 | 1 | 200 | |
559955 | 02.02.2020 | 250 | 2 | X | 250 |
559955 | 02.02.2020 | 450 | 1 | 200 | |
559955 | 02.02.2020 | 450 | 2 | 200 | |
559955 | 03.02.2020 | 600 | 2 | 450 |
This table shows me per Order level the corresponding manufacturing routing.
State 1 is the sequence for the process step and State 2 is the factor, if the step is finished (2) or is started (1).
Now I would like to get the SUM for quantity for the last process step (State 1).
That means I need to sum up the column "Quantity" per "State 1.
In addition, these filters should be set:
How can this dax measure be build?
This is my first try:
1. Try =
VAR _State1 =
MAXX (
ALLSELECTED ( 'Routing' ),
'Routing'[State 1]
)
RETURN
MAXX(
FILTER(
'Routing',
'Routing'[Code] = BLANK()
&& 'Routing'[State 1] = _State1
),
'Routing'[Quantity]
)
Is an iteration function like MAXX here appropriate?
How can I add, that '450' for State1 is above '600' ?
@amitchandak : thanks! In the example above the result is = 400 (State1 = 450; 200 +200)
User | Count |
---|---|
26 | |
12 | |
8 | |
8 | |
5 |
User | Count |
---|---|
30 | |
14 | |
12 | |
12 | |
7 |