Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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
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.
User | Count |
---|---|
84 | |
71 | |
71 | |
68 | |
55 |
User | Count |
---|---|
94 | |
92 | |
91 | |
77 | |
70 |