Forum Discussion
DokterT
5 years agoNew Member
partial string filter based multiple selectedvalues
Hi all, I've been looking all over the web to achieve something (that might not even work in PowerBI). Anyhow, hopefully one of you is able to help me out here 🙂 This is my problem; I hav...
- 5 years ago
I'm not sure exactly how you want to use this so I've created one of the alternatives. With it you can see the code pattern and adapt it as necessary.
1. Place FactT[Group] in a table visual
2. Place SlicerT[Group] on a slicer
3. Create this measure. :
Show measure = COUNTROWS ( FILTER ( DISTINCT ( SlicerT[Group] ), SEARCH ( SlicerT[Group], SELECTEDVALUE ( FactT[Group] ), 1, 0 ) > 0 ) ) + 04. Set the measure above as a filter for the table visual. Choose Show then value is greater than 0. This will filter out the unwanted rows in tehe visual.
See it all at work in the attached file with some simplified tables
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers