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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
60 | |
55 |
User | Count |
---|---|
179 | |
108 | |
105 | |
71 | |
70 |