Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
New GOAL = FILTER('Table 2',’Table 2'[STATUS]="D"||Table2'[STATUS]="E"&&RELATED('Table 1'[STATUS]<>"E")
Is this formula correct?
Solved! Go to Solution.
AND and OR are functions in the DAX, so maybe you can write it as follow:
New Goal = FILTER ( Table2, AND ( OR ( Table2[STATUS] = "D", Table2[STATUS] = "E" ), RELATED ( Table1[STATUS] ) <> "E" ) )
You can also use the following expression. It will produce the same result as the one I posted before:
New Goal2 = CALCULATETABLE ( Table2, OR ( Table2[STATUS] = "D", Table2[STATUS] = "E" ), Table1[STATUS] <> "E" )
The filter arguments in CALCULATETABLE are always put in a logical AND condition.
Thank you @Anonymous !
I have one more question.
Can the AND and OR functions be used when there are three or more filter items?
In the case of this time, the goals are D, E, F etc.
yes, you can use as many as you want, for example :
OR( OR(D, E), F) which equals to D || E|| F
For and as well,
AND(AND(D,E),F) which equals to D && E && F
but you have to take care of the combination of these two.
@Anonymous
I understand! Thank you!
Hi @Eiji77,
Kindly mark the answer as solution to close the case please.
Regards,
Frank
AND and OR are functions in the DAX, so maybe you can write it as follow:
New Goal = FILTER ( Table2, AND ( OR ( Table2[STATUS] = "D", Table2[STATUS] = "E" ), RELATED ( Table1[STATUS] ) <> "E" ) )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |