Forum Discussion
Create a Calculated Table using a UNION that preserves all values in one table
Hi mcairney,
From your pbix, it seems that you have created the relationship like below. So when you select the slicer based on Site Key from User Site table, it will show the filtered value.
I'm a little confused about your requirement, do you only want to get the all rows like below which won't be filtered by the selection of the slicer.
If it is, you could delete the relationship between the table User Site and All Sites, but that slicer seems to be meaningless if you remove the relationship.
Best Regards,
Cherry
Hi Cherry
The relationships were where I was also trying different options to find what works.
What I need is to have 2 sets of Sites and then combine them. However only the rows from the "User Site" table can be filtered and the ones in the "Reference Site" table are all included. The combined set should then filter the "Site Metrics" table and the final data set then used on the chart to show the "Reference Site" differently from the "User Site".
So as I select e.g. the value "Kof18" in the slicer, the final table should have the values "Par15", "Feb22" and "Kof18"