Slicing Columna A based on Column B

[dw700d]

I would like  to create a slicer Based on "yes" and "no". The logic would be as follows

if a [President] has a [Partner] then "Yes" if not then "NO".

So for example, if I selected yes in the slicer Dave and Carl would populate because they have a partner and if I select no in the slicer then Joe and Donald would populate because they do not.

President	Vice President	Partner
Dave	Bill	A
Dave	Kevin	B
Dave	John	C
Carl	Aaron	D
Carl	Greg	E
Carl	Gary	F
Dave	Lamr	null
Carl	Patrick	null
Joe	Anthony	null
Donald	Isabella	null

What is the most effective way to accomplish this ? I am open to creating a measure or making adjustments in the query editor?

[amitchandak]

@dw700d , Try a measure like

measure =

var _sel = selectedvalue(flag[flag])

return

if(_sel = "Yes", countrows(filter(Table, not(isblank(Table[Partner])) ) ),
countrows(except( Summarize(filter(Table, isblank(Table[Partner])), Table[President]),Summarize(filter(Table, not(isblank(Table[Partner]))), Table[President])))
)

[dw700d]

@amitchandak thank you , can you add some contect? Am i Dropping this measure in  the slicer? or the table?

Should I be creating  a custom column  with yes if partner is not null to be me slicer?