topic Using two different columns from different tables in a DAX measure in DAX Commands and Tips

Using two different columns from different tables in a DAX measure

Anonymous — Mon, 03 Oct 2022 11:42:47 GMT

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 — Tue, 04 Oct 2022 07:12:17 GMT

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

Anonymous — Thu, 06 Oct 2022 11:06:41 GMT

Thanks for the awnser!

Helped me a lot.

Best regards,

Daniel.