filter with two tables

[Anonymous]

Hi guys,

I have 2 tables, table A and Table B, both have a lot of columns and I have several relationships between boths.

One relationship (but not the active one) is "client" to "client". How could I make some dax which help me to get a filter visualization, with all the clients of both tables, merging when the client match in both tables?

Regards

Eduardo Silva

[v-yingjl]

Hi @Anonymous ,

Based on your description, not certain what is your expected output. As @ camargos88 mentioned, you can use Userelationship() to use the inactive relationship in dax, but what did "with all the clients of both tables, merging when the client match in both tables" represent seems not very clear.

Could you please consider sharing more details like some sample data or screenshots etc. for further discussion?

Sample data and expected output would help tremendously.
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Best Regards,

Yingjie Li

[amitchandak]

@Anonymous , please create common dimesions like client, date etc and try to build star schema. And join them with both the tables.

refer to my video on how to create that common/dimesnion table : https://youtu.be/Bkf35Roman8

Why Star Schema: https://www.sqlbi.com/articles/the-importance-of-star-schemas-in-power-bi/

Bridge table -https://www.seerinteractive.com/blog/join-many-many-power-bi/

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.

[camargos88]

Hi @Anonymous ,

You can use the function USERELATIONSHIP to activate an inactive relationship while filtering:

https://docs.microsoft.com/en-us/dax/userelationship-function-dax

[Anonymous]

Hi, @camargos88 

Thank you so much for your support, but I've been using it for sum and mix some relationships, but I don't have clear what should I write after "calculate(" if I don't want any math, I just want the merge of both columns.

Regards