DAX

Question

Hi everyone,I have 2 tables:ID_STEPSTEPGOAL1A102B123C154D5&nbsp;AND:&nbsp;ITEMID_STEPSTEPDURATION11111A511112B1011113C1511114D2022221A1022221A522222B1022223C1522224D2022221A322221A833331A833332B033333C544441A044442B6The relation is by the ID_STEP Field.I need get the actual Goal Step and the Total Duration fields. The result I hope is this:ITEMACTUAL_STEPGOAL STEPTOTAL DURATION111121252222110263333315544442126How can i do It?&nbsp;Thanks!!

hasan · Answer

what is the ACTUAL_STEP at the last table?

ajimenez · Answer

Hasan&nbsp;It is the STEP in which the ITEM&nbsp;is currently, it is the actual row. This field is the same ID_STEP, and I need get the Goal for this STEP and&nbsp;the total sum of field&nbsp;DURATION.Thanks!!

ajimenez · Answer

The last table is an example, is a matrix in wich i want to get the values when, for example, i filter by the ITEM = 2222 in the STEP = 1, etc. This is another example for the ITEM 2222:

ITEM	STEP	*GOAL*	*DURATION*
2222	1	10	26
2222	2	12	10
2222	3	15	15
2222	4	5	20

I only need to calculate de red fields, using DAX measures.

Thanks!!

v-jiascu-msft · Answer

Hi&nbsp;ajimenez,&nbsp;Maybe you don't need a DAX measure. Please have a look at the picture.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Best Regards!Dale

v-jiascu-msft · Answer

Hi&nbsp;ajimenez,&nbsp;Could you please mark the proper answer as solution or share the answer if it's convenient for you? That will be a help to the others.&nbsp;Best Regards!Dale

Forum Discussion

DAX

6 Replies

Related content

Dax

DAX

DAX Behavior

DAX Formula Help

DAX

ITEM	ID_STEP	STEP	DURATION
1111	1	A	5
1111	2	B	10
1111	3	C	15
1111	4	D	20
2222	1	A	10
2222	1	A	5
2222	2	B	10
2222	3	C	15
2222	4	D	20
2222	1	A	3
2222	1	A	8
3333	1	A	8
3333	2	B	0
3333	3	C	5
4444	1	A	0
4444	2	B	6

ITEM	ACTUAL_STEP	GOAL STEP	TOTAL DURATION
1111	2	12	5
2222	1	10	26
3333	3	15	5
4444	2	12	6