Forum Discussion
Dynamic filtering/slicing if text contains
Hi DennisGaida
May be you could use a MEASURE like
Measure = VAR searchvalue = SEARCH ( SELECTEDVALUE ( Text_Queries[Column1] ), SELECTEDVALUE ( Table1[Text] ), , BLANK () ) RETURN IF ( searchvalue > 0, "Found" )See the attached file. I am not sure if this what you need
One the same example: Do you know how to COUNT the number of rows currently filtered?
Using a Card with a Count on e.g. Table1[Date] it always returns 3 no matter how I filter. And cards cannot have visual filters applied unfortunately.
Community ChampionHi DennisGaida
Sorry for late reply
You can use this MEASURE. File attached as well
Countrows = COUNTROWS ( FILTER ( Table1, [Measure] = "Found" ) )
Hi Zubair_Muhammad,
The Measure for the list works great, but whenever I select more than one item from Column1, the filter appears to cancel out and show all results as if no filter was applied. Selecting 1 filter row from Column1 works as expected. How can we enable multi-select?
- Zubair_Muhammad
Good Question
In that case we can adjust the MEASURE as follows
Measure = VAR mycount = COUNTROWS ( FILTER ( VALUES ( Text_Queries[Column1] ), SEARCH ( [Column1], SELECTEDVALUE ( Table1[Text] ),, BLANK () ) ) ) RETURN IF ( mycount > 0, "found" )
