Cross Filter Relationship..

[Yagevendra]

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.

[MFelix]

Hi @Yagevendra ,

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.

[Yagevendra]

@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?

[MFelix]

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.

[Yagevendra]

@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