Forum Discussion
dw700d
Post Patron
Post PatronSlicing Columna A based on Column B
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...
amitchandak
Super User
Super Userdw700d , 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])))
)
dw700dPost Patron
Post Patronamitchandak 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?