I have a dimension table in a tabular model that has been setup to only retrieve records that are in a fact table, by using the query editor and adding a where clause (where the dimension key is in the fact table). I've had a request to be able to view all the records in this dimension for a separate report. At the minute the Power BI reports using this dimension have good slicers with just the relevant records and not all the records in this dimension. My question is, what is the best way to be able to keep the slicer data trim according to the keys in the fact whilst also being able to create a report that would detail all of the records in this dimension, I'm just a little unsure of the best approach? I'm not sure whether to remove the where clause to bring all the records in and then filter the data out in the Power BI report or create a different solution.
Any help or ideas would be greatly appreciated. :)