Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Not Selected Values

Is there a way to list non selected values from the slicer?   I have a Customer Table with Column CUST Slicer is PIN to CUST Column, if User selects multiple value such as CUST1, CUST5, CUST 8,....
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi Anonymous,

     

    Please download the demo in the attachment.

    Measure =
CONCATENATEX (
    FILTER ( ALL ( 'Table1'[Cust] ), NOT [Cust] IN VALUES ( Table1[Cust] ) ),
    [Cust],
    ","
)

    Not-Selected-Values

     

    Best Regards,
    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Anonymous,

 

Please download the demo in the attachment.

Measure =
CONCATENATEX (
    FILTER ( ALL ( 'Table1'[Cust] ), NOT [Cust] IN VALUES ( Table1[Cust] ) ),
    [Cust],
    ","
)

Not-Selected-Values

 

Best Regards,
Dale

Giorgi1989's avatar
Giorgi1989
Icon for Advocate II rankAdvocate II
4 years ago

Amazing! Thank you!