Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
@Anonymous , seem like you are creating a new table, that will not tale slicer values
Create a common dimension year, join with both tables. And create measures from both tables and analyze against common dimension
I have tried to do this so now have a table called 'Year_Table' with variable 'Year'.
However, I have joined this table 1 to many from (Year_table[Year] to MORT[Mort_Year] which is fine. However, I then tried to join (Year_table[Year] to COMP[Comp_Year] but it won't let me due to the following message:
"an active set of indirect relationships already exists between these tables. To make this relationship active, set the Cross filter to "Single", delete, or deactivate any indirect relationship first"
Any idea how to bypass this please?
User | Count |
---|---|
107 | |
88 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |