Forum Discussion
Filter a visual using two different entities
Hello, I have the following scenario: I'm trying to filter Report A and B using the Entity A Request date, but, as the field is not in the related 1-N Entity, it shows no data on the Repo...
ToddChitt
Super User
Super UserIf you are on Entity B, then you can create a Calculated Column :
My Column from Entity A = RELATED ( 'Entity A' [Some Column Name] )
But you shouldn't have to. This is basic STAR schema modelling.
Suppose you have a fact table (like Entity B) of Sales. And one of those columns is Product Key. Then you also have a Product dimension (Entity A) that is joined to Sales on Product Key (one-to-many, one product has many sales) then any filtering you do of Product WILL filter Sales.
If you cannot share your data, can you give us a glimpse of it? Screen shot? Obfuscated samples?
If not, there is not much else we can do.