I need a dax logic similar to sql logic

[Anonymous]

a = select org from policy where policy = 123

then 

b = select accno from policy where org in a

then 

select org from policy where acc in b 

i want to apply this logic in dax how can i get this 

the performance should also be good

[lbendlin]

ok. what have you tried and where are you stuck?

[Anonymous]

I have tried it like this, its working but the performance impact is huge. I need it much quicker.

selectcolumns(filter(policy,policy[org] in (

selectcolumns(filter(policy,policy[account] in (

selectcolumns(filter(policy,policy[org] in (selectcolumns(filter(policy,policy[number]=123),"org",policy[org]))),"account",policy[account]))),"org",policy[org]))),"policy",policy[policy])

[lbendlin]

you can implement this easier via REMOVEFILTERS.  It's a standard "filtering up" pattern.

Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.

[Anonymous]

account	org	pol
x	a	789
z	b	456
y	aa	123
z	aa	101
yz	c	110
y	d	111

suppose this is my dataset, It should check from right to left. 

1. for pol= 123 i am fetching all the org  such as "aa" & "ab" as you can see.

2. Now based on org in (aa) i am fetching all accounts  and the result will be y & z

2. Now based on account y & z it should fetch all the pol. such as 456,123,101,111. this is my final result i want.

[lbendlin]

How is pol 123 linked to org ab ? 

[Anonymous]

apologies thats a mistake ive corrected now.

[lbendlin]

Org Pols = 
var o = [  org]
var a = CALCULATETABLE(SUMMARIZE('Table',[account]),ALLSELECTED(),'Table'[  org]=o) 
var b = CALCULATETABLE(SUMMARIZE('Table',[pol]),ALLSELECTED(),a)
return CONCATENATEX(b,[pol],",")

Org Pols is a calculated column