Slicer select from two Columns (Filter charts)

[kala2]

I have two Columns as displayed below:

And my slicer is: 

Is it possible to filter only the "Yes" values when select some of the selections?
Created a DAX but seems not to be working.

VAR Selection =

      SELECTEDVALUE ( Table[SBU Attribution] )

RETURN

     SWITCH (

        Selection = "BAS",  SUMMARIZE(FILTER(Table, Table[SBU Attribution Value]="Yes")

     )

[MFelix · Accepted solution]

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.

[Icey · Accepted solution]

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.

[Icey]

Hi @kala2 ,

Can my reply above solve your problem?

Best Regards,

Icey

[MFelix · Accepted solution]

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.