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 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.

PresidentVice PresidentPartner
DaveBillA
DaveKevinB
DaveJohnC
CarlAaronD
CarlGregE
CarlGaryF
DaveLamrnull
CarlPatricknull
JoeAnthonynull
DonaldIsabellanull

 

 

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

Need Help

2 Replies

  • 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?