Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a filter that includes the line 'Loneliness All Data'[VARIABLE] == "Parliamentary Constituency". I also want this filter to include "LGD" i.e, if the variable column is equal to Parliamentary Constituency or LGD. How do I add in the LGD? I'm sure this must be easy but I'm a newbie and can't figure it out at all!
Here is my code:
Solved! Go to Solution.
Hi @andytmcc,
You can use it like this && 'Loneliness All Data'[VARIABLE] IN {"Parliamentary Constituency", "LGD"}
@ReneMoawad How would I put this same filter requirement FILTER('Loneliness All Data'[VARIABLE] IN {"Parliamentary Constituency", "LGD"} into this code:
Thanks!
Sorry, i didn't mean how would I use the || in that. I meant how would I put this filter FILTER('Loneliness All Data'[VARIABLE] IN {"Parliamentary Constituency", "LGD"} into this code below:
Thank you so much!
Hi @ReneMoawad ,
That's fantastic - thank you so much! I had been trying to use OR but couldn't figure it out. First time coming across IN for me!
Also instead of OR you can use double vertical bar ||
Hi @andytmcc,
You can use it like this && 'Loneliness All Data'[VARIABLE] IN {"Parliamentary Constituency", "LGD"}
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
111 | |
96 | |
96 | |
67 | |
63 |