Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
can i use not in in my DAX using a variable like
var abc = values('table 2'[number]
FILTER ('table 1 ' , NOT ('table 1 '[Number]) IN {abc} )
Solved! Go to Solution.
@kumar27 Should just be:
var abc = values('table 2'[number]
FILTER ('table 1' , NOT ('table 1'[Number] IN abc ))
Thanks @Greg_Deckler , it wrks .
also wanted to know , we can use except also i same scenarios ?
@kumar27 Yes, using EXCEPT should be another way of accomplishing this.
@kumar27 Should just be:
var abc = values('table 2'[number]
FILTER ('table 1' , NOT ('table 1'[Number] IN abc ))
| User | Count |
|---|---|
| 55 | |
| 37 | |
| 26 | |
| 17 | |
| 17 |
| User | Count |
|---|---|
| 69 | |
| 58 | |
| 39 | |
| 21 | |
| 21 |