troubleshooting Question

SSAS Tabular - Dimension table

Avatar of H
H asked on
SSASPower BI* SSAS TAbular
8 Comments1 Solution66 ViewsLast Modified:
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. :)

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros