Forum Discussion

dw700d's avatar
dw700d
Icon for Post Patron rankPost Patron
3 years ago

Slicing 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...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

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's avatar
    dw700d
    Icon for Post Patron rankPost Patron
    3 years ago

    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?