Forum Discussion
Cross Filter Relationship..
Hi Anonymous ,
When you use the crossfilter what happens is that your data is filter from anyside of the relationship so in this case when you use filter1 your Data table gets filter by that filter and then the Data table filter out the other 3 tables so you only get the values that are withing the lines selected on the filter1.
Whats is the purpose of this calculation can you please share some more information and expected result?
if you can please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.
If the information is sensitive please share it trough private message.
MFelix my purpose is that i don't want to use both directional relationship because i will receive more fact file in future to connect with this same lookup files.
As i mentioned in above comment i used cross filter function instead of both directional relation.
Both direction relationship results are good when i select filter 1 the filter2 will change and show me the correct output for metric 1 and metric 2 these are the different charts as you can see on my above screenshot.
Here is my sample data.
| Date | Filter 1 | Filter 2 | Filter 3 | Filter 4 | Metric | Graph name | value |
| 1 | 1 | 102 | 101 | 1 | A | PP | 1 |
| 2 | 1 | 102 | 102 | 2 | B | TT | 2 |
| 3 | 1 | 103 | 103 | 3 | C | TT | 1 |
| 1 | 2 | 102 | 102 | 1 | D | TT | 1 |
| 2 | 2 | 103 | 103 | 2 | A | TT | 1 |
| 3 | 2 | 101 | 101 | 3 | B | PP | 2 |
| 4 | 2 | 105 | 105 | 4 | C | PP | 2 |
| 1 | 3 | 101 | 101 | 1 | D | PP | 1 |
| 2 | 3 | 103 | 103 | 2 | C | PP | 2 |
| 2 | 3 | 104 | 104 | 3 | B | TT | 1 |
| 4 | 3 | 105 | 105 | 4 | B | PP | 1 |
| 5 | 3 | 102 | 102 | 2 | C | TT | 2 |
| 7 | 3 | 106 | 106 | 4 | D | PP | 1 |
| 7 | 3 | 107 | 107 | 2 | C | TT | 2 |
| 8 | 4 | 108 | 108 | 1 | D | TT | 1 |
| 8 | 4 | 101 | 101 | 3 | D | TT | 2 |
| 1 | 1 | 101 | 101 | 1 | A | PP | 1 |
| 2 | 1 | 102 | 102 | 2 | B | TT | 2 |
| 3 | 1 | 103 | 103 | 3 | C | TT | 1 |
| 1 | 2 | 102 | 102 | 1 | D | TT | 1 |
| 2 | 2 | 103 | 103 | 2 | A | TT | 1 |
| 3 | 2 | 101 | 101 | 3 | B | PP | 2 |
| 4 | 2 | 105 | 105 | 4 | C | PP | 2 |
| 1 | 3 | 101 | 101 | 1 | D | PP | 1 |
| 2 | 3 | 103 | 103 | 2 | C | PP | 2 |
| 2 | 3 | 104 | 104 | 3 | B | TT | 1 |
| 4 | 3 | 105 | 105 | 4 | B | PP | 1 |
| 5 | 3 | 102 | 102 | 2 | C | TT | 2 |
| 7 | 3 | 106 | 106 | 4 | D | PP | 1 |
| 7 | 3 | 107 | 107 | 2 | C | TT | 2 |
| 8 | 8 | 108 | 108 | 1 | D | TT | 1 |
| 8 | 8 | 101 | 101 | 3 | D | TT | 2 |
Filter 1 have some values when i select 8 from filter 1 the expected output is 108 and 101 for chart 2 (TT) but the problem is that i put my both measure which i have created with cross filter function in a filter 2 filter pane for enable cross filtering effect.
I have to put both measure becasue same filter working for both chart
when i remove chart 1 measure from filter pane it will working fine and give the result as i expected and some filter applicable for chart 1 only it will not show me the value in filter 2. thats the problem
Both directional relationship output is working but the cross filter function not may be i used wrong approch.
can you please help me?
Can 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 1Filter 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