Slicer select from two Columns (Filter charts)

Hi kala2 ,

 

Not really sure about what you need to achieve but you measure is incorrect try the following change:

VAR Selection =
      SELECTEDVALUE ( Table[SBU Attribution] )
RETURN
     SWITCH (
        Selection,  "BAS",  COUNTROWS(SUMMARIZE(FILTER(Table, Table[SBU Attribution Value]="Yes"))
     )

 

Now use this measure has a filter of your visualization and set it has has greater than 0 or different from blank.

Hi kala2 ,

 

You can just add the [SBU Attribution Value] column into a filter field and set as "is Yes".

 

Reference: Add a filter to a report in Power BI - Power BI | Microsoft Docs

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.