Forum Discussion
DAX
Hi everyone, I have 2 tables: ID_STEP STEP GOAL 1 A 10 2 B 12 3 C 15 4 D 5 AND: ITEM ID_STEP STEP DURATION 1111 1 A 5 1111 2 B 10 1111 3 C...
Hasan It is the STEP in which the ITEM is currently, it is the actual row. This field is the same ID_STEP, and I need get the Goal for this STEP and the total sum of field DURATION.
Thanks!!
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!!