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

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

4 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft 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

    • powerBIpeon's avatar
      powerBIpeon
      Helper II
      7 years ago

       

       

      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's avatar
        v-jiascu-msft
        Microsoft Employee
        7 years ago

        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