Not Selected Values

[Anonymous]

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,.....etc. Is there a way to list rest of the not selected values in the grid. I mean like opposite to ALLSelected?

Thanks in Advance.

[v-jiascu-msft · Accepted solution]

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

[Giorgi1989]

Amazing! Thank you!

[powerBIpeon]

@v-jiascu-msft

What if the the customers where grouped? How would the relationship or function look like?

Group 1 = cust1 to cust5

Group 2 = cust1 to cust3

Group 3 = cust3, cust4

[v-jiascu-msft]

Hi @powerBIpeon,

I would suggest you create a new thread in this forum with a little sample. The solution depends on your data model. 

Best Regards,
Dale