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.
filter 1 table to filter 2 table (Both table connected with fact table) It was working good when i put my measure to VIsual level filter.
But the problem is my table filter 1 and, filter 2 apply to another visual also and inside the values in filter tables might not be for visual 1 or some values are not be applicable for visual 2.
i have created 2 different measure for both visual and applied the same cross filter on it and put it on visual level filter.
When i tried to filter "filter 1" table and select one value which is for visual 2 but the 2nd filter shown me only blank becasue this value not applicable for 1 visual.
Atteched screenshot here
Need help to resolve it.
4 Replies
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.
