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.
Hi All,
How can I filter all the rows that contain text LOC in the Risk Categories column as shown in a table below? I have tried using ? or * as wildcards text but they did not work.
Solved! Go to Solution.
@MelbourneBadger Ohhhhhh... I did not get that from your original post, I was misled by the picture and just thought you were trying to filter the data view. OK, in that case you need to use FIND, SEARCH or CONTAINSTRING. So, something like:
New Table = FILTER('Old Table',FIND("LOC ",[Column],,0) <>0)
@MelbourneBadger - Use the Text filters fly-out and use Contains.
Thank you for your response @Greg_Deckler
What did you mean by "uset the Text filters fly-out"? Sorry I'm new to DAX. Thank you before-hand.
@MelbourneBadger - Sorry, did the pic not post, I'll try again, this is not DAX:
Thank you @Greg_Deckler
I am actually trying to create new table with DAX expression based on data in another larger table using Filter function based on multiple boolean expressions
@MelbourneBadger Ohhhhhh... I did not get that from your original post, I was misled by the picture and just thought you were trying to filter the data view. OK, in that case you need to use FIND, SEARCH or CONTAINSTRING. So, something like:
New Table = FILTER('Old Table',FIND("LOC ",[Column],,0) <>0)
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |