Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I need to create a drill-through between two tables, joined by many-to-on relationship. The master table contains the "many" records, while the "detail" table contains single row with lot of attibutes.
After applying the join column as the drill-through column, the "detail" table always shows all the existing records, it simply does not filter by the drill through value
If I change the roles, if I want to do a drill through from the second table on to the first, based on the same column, the drill through works perfectly, it shows the expected rows, the ones that fullfill the drill through filter.
Any ideas what I might be doing wrong?
Thanks
Viktor
Solved! Go to Solution.
Thanks Amitchandak for the quick reply. Actually, the join was fine, but after double-and triple checking I found the problem (or at least I found a solution that works for me 🙂 )
If the cross-filter direction is set to "both" then the drill through works as expected.
Thanks
Viktor
@Anonymous , I doubt the link column in visual and link column is table is not same. Some join problem.
Can you share data model?
Thanks Amitchandak for the quick reply. Actually, the join was fine, but after double-and triple checking I found the problem (or at least I found a solution that works for me 🙂 )
If the cross-filter direction is set to "both" then the drill through works as expected.
Thanks
Viktor
User | Count |
---|---|
102 | |
92 | |
85 | |
78 | |
71 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |