a = select org from policy where policy = 123
b = select accno from policy where org in a
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
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])
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.
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.
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
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.