Using two different columns from different tables in a DAX measure

[Anonymous]

Good timezone, everyone!

I need some help with a DAX measure that I'm struggling a bit.

This is my actual measure that I'm using:

it works wonders, but I need to do some improvement on it.

I have this two tables, with a common ID for realtionship beetween the tables.

Every "entas_cod" is a different entity with unique values, like below.

Can I have something that work like a filter to use like "entas_cod = 1" then it will use the selected value in the columns for that measure?

[Anonymous]

Thanks for the awnser!

Helped me a lot.

Best regards,

Daniel.

[v-mengzhu-msft · Accepted solution]

Hi @Anonymous ,

You can directly put slicer to choose the value you want.

It is equivalent to you just put the columns you need to select values into each of the three slicer, and you are done.

Best regards,

Community Support Team Selina zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly