Forum Discussion
Filter 1 table equivalent to another
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
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.
2 Replies
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.