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,
Below are the tables and relationship. They contain sample data and any help would be much appreciated.
1. [fact_Transaction]
2. [dim_transaction_Policy]
3. [dim_Policy]
4. What I would like to achieve is - when user click a Policy (or multiple), below table will show the relevant Transaction record(s)
5. The relationship in Model is as below. I think might have some issues, as it doesn't behave as I expect.
Thank you in advance
Solved! Go to Solution.
Hi @spagad6263 ,
Yes, it's the easiest way.
Prior to this, the desired effect could not be obtained because the cross-filtering relationship between [fact_Transaction] table and [dim_Policy] table was unidirectional.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
With the current relationship, if I select an item in the slicer (dim_Policy), the table (fact_Transaction) doesn't change correspondingly.
I have to change the relationship to both directions between the fact table and the intermediate table. It seems working now, but I am not sure if this is the correct approach. Thanks
Hi @spagad6263 ,
Yes, it's the easiest way.
Prior to this, the desired effect could not be obtained because the cross-filtering relationship between [fact_Transaction] table and [dim_Policy] table was unidirectional.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
What problem are you facing?
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |