Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have 1,000 pages in a column.
Is there a calculated measure which will for example will allow me to filter my table Y and Column Z and return only the total numbers of pages which contain the word apple in the URL.
Solved! Go to Solution.
If the word that you're looking for is fixed (as in - you can hardcode it), then you can create a DAX measure using the SEARCH, FIND or CONTAINSSTRING functions.
If you need to be able to search for a word, then the default slicer selection isn't that great. I would recommend you create a scorecard, and then put column Z and aggregate using COUNT. Then, in the visual filter select the advanced filtering option and let the user enter the search term.
If the word that you're looking for is fixed (as in - you can hardcode it), then you can create a DAX measure using the SEARCH, FIND or CONTAINSSTRING functions.
If you need to be able to search for a word, then the default slicer selection isn't that great. I would recommend you create a scorecard, and then put column Z and aggregate using COUNT. Then, in the visual filter select the advanced filtering option and let the user enter the search term.
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
64 |