Forum Discussion
Cross Filter Relationship..
Hi All, I have one senerio where i have 1 fact table and 4 dimaintion table with single to many relationship, i have used crossfilter function with the calculate function and trying to filter. ...
MFelix
Super User
Super UserCan you please tell me what are the values in the Filter tables, are they the ones in the columns on the data you have sent or something else? I see two columns for each of the filter tables.
MFelix Hi,
Actually i have 4 filter table filter 1, 2, 3 and 4 with same key as i mentioned in data table.
Filter table 1
| Filter 1 | Name |
| 1 | Hotstar |
| 2 | Prime |
| 3 | BBC |
| 4 | Netflix |
| 8 | Star |
Filter table 2
| Filter 2 | Name |
| 101 | A |
| 102 | B |
| 103 | C |
| 105 | D |
| 104 | E |
| 106 | F |
| 107 | G |
| 108 | H |
Filter table 3
| Filter 3 | Name |
| 101 | |
| 102 | |
| 103 | |
| 105 | |
| 104 | |
| 106 | |
| 107 | |
| 108 |
Filter table 4
| Filter 4 | Name |
| 1 | TV |
| 2 | Tablet |
| 3 | PC |
| 4 | Mobile |