Filter 1 table equivalent to another

[Anonymous]

Hi guys,

I have a table stacked by 3 pipelines and to differentiate them in the filter, I created a column called product.

I'm using a dimension called campaign that uses a key with the merge of campaign, set of ads and ads.

I need, for example, to create this product filter that brings me data from the pipe table that references each campaign.

So for example: In the Investment table I have campaign x, campaign set y and ad z. How many leads do I have in the Pipe table for campaign x, campaign set y and ad z and Product X? Those are the results I would like to get.

How can I do this?

Thanks, 

Karina

[Anonymous · Accepted solution]

@Anonymous 
In case you cannot change the existing relationship in your model. Try add an inactive relationship between Pipe table and Investment table using product column.

And create a measure use userelationship() to call out the relation. Check the blog:

Using USERELATIONSHIP in DAX - SQLBI

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thank you so much @Anonymous