Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
ok. what have you tried and where are you stuck?
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.
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.
How is pol 123 linked to org ab ?
apologies thats a mistake ive corrected now.
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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
109 | |
107 | |
92 | |
67 |
User | Count |
---|---|
162 | |
133 | |
132 | |
93 | |
91 |