Solved: Relationship between tables

karinafreitass · ‎10-28-2020

Hi Guys,

Please,

What function could I use to relate the flançamento table and dimCargos?

I have the column of values "Debito" in the table "fLançamento", and I would like to filter to add these values in the table "dimCargo".

Grata,

Karina

mahoneypat · ‎10-28-2020

Do one's ID values match those in the other table? If so, you can use TREATAS to pass a filter between them unrelatedly, or you can use the USERELATIONSHIP function once you perform an inactive relationship between those tables.

Best regards

Pat

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.

@mahoneypa HoosierBI on YouTube

View solution in original post

mahoneypat · ‎10-28-2020

Do one's ID values match those in the other table? If so, you can use TREATAS to pass a filter between them unrelatedly, or you can use the USERELATIONSHIP function once you perform an inactive relationship between those tables.

Best regards

Pat

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.

@mahoneypa HoosierBI on YouTube