DAX help - Measure based on other measure conditions

Fátima — Thu, 02 Mar 2023 08:31:48 GMT

Hi!

I need to obtain the state of some registries based on some measures.

I have some registries like this:

Then, I have two tables that tells me if those registries have completed some actions, A registry can complete an action several times, in which case we will only need the last one:

action 1

ID Registry Date

1 R1 01/01/2022

2 R1 02/01/2022

3 R3 01/01/2022

4 R4 02/02/2022

action 2

ID Registry Date

1 R1 01/01/2022

2 R3 01/01/2022

3 R4 02/02/2022

For each of those tables I have a measure that gives me the Id if the action is active, let's call them measure1 and mesure2, which results represented on the tables would be:

action 1

ID Registry Date measure1

1 R1 01/01/2022 --> This one would be blank, because it's not active, since the same registry has made the same action on a later date.

2 R1 02/01/2022 2

3 R3 01/01/2022 3

4 R4 02/02/2022 4

action 2

ID Registry Date measure2

1 R1 01/01/2022 1

2 R4 02/02/2022 2

I would need a measure on the first table that returns "action 2" if it has it, "action 1" if it only has action 1 and not action 2, and "Nothing" if it has none, so it would be:

R1 action 2

R2 nothing

R3 action1

R4 action2

It's important this is a measure, because I'm going to have to filter it by date, so for example if I selected everything that has happened until 01/01/1022, the result of the measure would be:

R1 action 2

R2 nothing

R3 action1

R4 nothing

Is this possible?

Thanks! Regards!

topic DAX help - Measure based on other measure conditions in DAX Commands and Tips

DAX help - Measure based on other measure conditions