Forum Discussion

DokterT's avatar
DokterT
New Member
5 years ago
Solved

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...
  • AlB's avatar
    AlB
    5 years ago

    DokterT 

    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
    )
) + 0

     

    4. 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 

DokterT's avatar
DokterT
New Member
5 years ago

AlBThanks for the advice, will try and get that to work.

As for a sample with fictional names (fruits/veggies might not be the best reallife example but you get the point hopefully);

 

The unrelated filter table contains one column with the follwing groups;

- "Apples"
- "Bananas"

- "Melons"

- "Onions"

- "Potatoes"

 

Sample of facts table;

ActivityID | Group                      | Details 

123212         | Potatoes // Onions  | jalfjklajf
142232         | Potatoes                  | kjfkljakdfa
154767         | Melons                    | jkdhflahfhajkf
234234         | Bananas // Melons  | dadfjhejks

So what I basically want to achieve is to filter the fact table based on the selection in the unrelated filter table.

Hence, selecting potatoes will give me;

ActivityID | Group                      | Details 

123212         | Potatoes // Onions  | jalfjklajf
142232         | Potatoes                  | kjfkljakdfa

Selecting Melons AND Onions should give me;

ActivityID | Group                           | Details 

123212         | Potatoes // Onions  | jalfjklajf
154767         | Melons                    | jkdhflahfhajkf
234234         | Bananas // Melons  | dadfjhejks

 

And all other variations based on multiple selections.