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 Report A and B. The same happens with the Entity A Contract Type field.
Thanks in advance!
5 Replies
Can you give us a sample of your data? And I assume that the middle row of four boxes are SLICERS on a report page? And the bottom two are Charts or Graphs?
Also, what is the relationship between A and B?
Middle rows: Yes those are slicers on a report page.
bottom two: Graphs
Relationship: 1 to many (Entity A to many Entity B)
I can't upload sample data. It's a production environment.
Please explain the "Average of Days" for the Reports. How do you AVERAGE a Day?
Instead of a chart, make them Table visuals and make sure that you have rows in the table that satisfy all slicers you want to apply.
How can i get a row value from Entity A to Entity B?
It's possible to have an intermediate table with the values of both entities?
If 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.
