Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a single visual table but its sourced from two seperate excel sheets.
The visual table needs to be filtered down, maybe a button that I can press to compare column A with column B and Column C with column D
B and D are from the other excel sheet
I have a many to many relationship already set for these tables.
I cant seem to create a measure or extra column that will do this comparison. Does it have something to do with the relationship?
Solved! Go to Solution.
*:* relationships are not always the greatest. You could create a summary table of the unique keys from both tables and then create a relationship between those 3 tables (i.e. Summary table -> T1, Summary Table -> T2).
But without more details on what you're trying to accomplish or a sample data set, it's hard to help you further.
Hi @PCarson00
Can you please try inactive relationship between two table and use USERELATIONSHIP dax to fine value for B & D from another table
https://www.youtube.com/watch?v=n_N_5PLyOIM
Please mark as SOLUTION if resolve your issue.
Thanks
Pijush
*:* relationships are not always the greatest. You could create a summary table of the unique keys from both tables and then create a relationship between those 3 tables (i.e. Summary table -> T1, Summary Table -> T2).
But without more details on what you're trying to accomplish or a sample data set, it's hard to help you further.
Thanks I ended up creating a merge into another table which is easier to work with.
User | Count |
---|---|
102 | |
91 | |
84 | |
77 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |