Forum Discussion
Impactful IndividualDAX equivalent of SQL's NOT IN?
Hi mmace1,
You need to place the NOT formula on the column and then use the in to make the level you need.
So you measure should look something like this:
MEASURE NOT IN = CALCULATE ( SUM ( Table1[Value] ); FILTER ( Table1; Table1[Category] = "C" && NOT ( Table1[CAT LEVEL] ) IN { 2; 3 } ) )As you can see below in category C the total is 1500 if you took out the category 2 and 3 it's 1000.
Regarrds,
MFelix
Super UserHi mmace1,
You need to place the NOT formula on the column and then use the in to make the level you need.
So you measure should look something like this:
MEASURE NOT IN =
CALCULATE (
SUM ( Table1[Value] );
FILTER (
Table1;
Table1[Category] = "C"
&& NOT ( Table1[CAT LEVEL] ) IN { 2; 3 }
)
)
As you can see below in category C the total is 1500 if you took out the category 2 and 3 it's 1000.
Regarrds,
MFelix
- mmace1
Typo on your measure name (it's not 2 & 3, but the Measure title says not 1 & 2).
Exactly the syntax I was looking for, thanks!
I solved this by using excel as a source. Following this method I don't have to work with HTML code in my power query to get all the sheets
https://stackoverflow.com/questions/45945815/how-to-connect-google-sheet-with-power-bi
