Forum Discussion
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,....
Hi Anonymous,
Please download the demo in the attachment.
Measure = CONCATENATEX ( FILTER ( ALL ( 'Table1'[Cust] ), NOT [Cust] IN VALUES ( Table1[Cust] ) ), [Cust], "," )
Best Regards,
Dale
Hi Anonymous,
Please download the demo in the attachment.
Measure = CONCATENATEX ( FILTER ( ALL ( 'Table1'[Cust] ), NOT [Cust] IN VALUES ( Table1[Cust] ) ), [Cust], "," )
Best Regards,
Dale
Amazing! Thank you!