Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi everyone,
I've been trying to do the following codes in a DAX formula, however, it is not working as it does via applying the filters on filter pane. I have Stage column with value from A to E and Other. I needed to exclude the A and Other which in sql, I'd do using NOT IN { } but here I tried several methods but it is not working, it uses only one value and field (either A or Other, not both),
also tried Filter ('data', NOT('data'[Stage]) IN {"A","Other"} ) but no luck.
Does anyone have any idea how can I exclude those 2 or 3 values from a field in this calculation?
var _Calc2 = CALCULATE(
SUM('data'[Credit])
,'data'[Field 1] = "Spend Management"
,'data'[Type] = "New"
,'data'[Stage] = "A"
,'data'[Stage] = "Other"
,'data'[Code] <> "1231"
)
Thanks!
Solved! Go to Solution.
Hi @k3rz0rg
try with this one ..
Note: If this post helps mark this one as accepted.
Hi @k3rz0rg
try with this one ..
Note: If this post helps mark this one as accepted.
Although this was marked as Solution randomly by default, however, it didn't work for me. While IN{ } works for the int values, it does not work for the texts in Power BI I found and had to create multiple variable for each IN filter and add those variables up in the return. Makes the code longer but at least works.
Thanks for the response though, I learned something new through that.
Hi,
Does this measure work?
var _Calc2 = CALCULATE(SUM('data'[Credit]),'data'[Field 1] = "Spend Management"&&'data'[Type] = "New"&&('data'[Stage] = "A"||'data'[Stage] = "Other")&&'data'[Code] <> "1231")
@k3rz0rg , try like
var _Calc2 = CALCULATE(
SUM('data'[Credit])
Filter( 'data', 'data'[Field 1] = "Spend Management"
&& 'data'[Type] = "New"
&& 'data'[Code] <> "1231" && not( ,'data'[Stage] in{ "A", "Other"})
) )
Thank you for the response, unfortunately I've already tried the FILTER() and tried your method as well but it is not considering multiple values inside IN { } , it only filters based on one value (in this case A between A and Other) no matter how many values I put inside the curly braces.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
76 | |
76 | |
55 | |
36 | |
34 |
User | Count |
---|---|
99 | |
56 | |
53 | |
44 | |
40 |