Forum Discussion

MikeThoreson's avatar
MikeThoreson
Frequent Visitor
2 years ago
Solved

Slicer Callouts Based on Contents in Another Table

HI, I have a table with account information including a column with state abbreviations; the accounts listed do not span the entire 50 states. I've created another table to list state abbreviations w...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi MikeThoreson 

    You can create a measure.

    Measure =
    IF ( MAX ( DIMCustomerTable[Account] ) <> BLANK (), 1, 0 )
    

    Then put the measure to the slicer visual filter, then it can only display the name with existed account.

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

  • MikeThoreson's avatar
    MikeThoreson
    2 years ago

    Yolo, thanks so much, that worked great!