Create measure to filter table

[RitikaKapoor]

Hi,

I have a table  A:

col1A	col2A	col3A
12	90	89
14	95	89
13	100	86

table B:

col1B	col2B
90	10000
95	90000
100	30000

table C:

col1C	col2C
89	wheels
86	head light

i need to have a dynamic  filter for  table A . 

Filter condition: (col2B >10000 and col2B  < 50000) OR col2B = 30000 AND col2C= wheels

i want to create a measure , for which if value is selected as 1, this condition should be applied on table A , otherwise not.

thanks, any help would be highly appreciated.

[amitchandak]

@RitikaKapoor , how to relate these three tables

[RitikaKapoor]

@amitchandak :

Fact-

Table A

(col 1A, col 2A, col 3A)

Dimension 1

Table B

(Col 1B,

Col 2B)

Dimension 2

Table C

(Col 1C,

Col 2C)

Relationships (n:1)

2A:1B

3A:1C

Thanks !