relationship not working properly

[Sujit_Thakur]

Dear all , I have following Index table

Model	Category	Sub Category
AB	Fist	Head
SB	Fist	Belt
DU	Velo	Shoe
DI	Velo	Rack

And a main data table as below 

Model	Location	Price	Pro
AB	Pune	23	Av
DI	Lucknow	31	AD
DU	Madras	43	WFW
SB	UP	42	FA
AB	Kolkata	23	QF

i gave a relation between them , using model column .
so what i expect  using table visual ,

Model	Category	Location	Price	Pro
AB	Fist	Pune	23	Av
DI	Velo	Lucknow	31	AD
DU	Velo	Madras	43	WFW
SB	Fist	UP	42	FA
AB	Fist	Kolkata	23	QF

but what i am getting is ,

Model	Category	Location	Price	Pro
AB	Fist	Pune	23	Av
AB	Velo
DI	Velo	Lucknow	31	AD
DI	Fist
DU	Velo	Madras	43	WFW
DU	Fist
SB	Fist	UP	42	FA
SB	Velo
AB	Fist	Kolkata	23	QF
AB	Velo

Even when i have given one to many relation between both tables using model field 
I too tried filtering both direction using security  filter but it didnt helped

@amitchandak  please help sir

Regards 
sujit

[amitchandak]

@Sujit_Thakur , Are taking model related column from the index table only. Please find the attached file after signature. I am getting correct result

[Sujit_Thakur · Accepted solution]

Dear @amitchandak ,

It was my fault 

I was returning 0 in a measure 

Var a = some expression

Return IF(ISBLANK (a),0, Countrows(some expression))

[v-jingzhang]

@Sujit_Thakur Has the problem been solved? If so, you may accept the appropriate reply as the solution or post your own solution to help close this topic. Thanks.

Best Regards,
Community Support Team _ Jing Zhang

[Sujit_Thakur]

@amitchandak sir ,
above is dummy data ,
please share some type of trouble shooting checklist for relationship