Forum Discussion

pmay's avatar
pmay
Icon for Resolver I rankResolver I
4 years ago
Solved

Disconnected Slicer to slice a table

So I have a table that contains some information about services, like this:   Service Value Chain Service Level ABC Ops, HR Bronze DEF IT, Ops Gold GHI IT, HR Silver JKL HR,...
Need Help
  • rohit_singh's avatar
    rohit_singh
    4 years ago

    Hi pmay ,

    Please try this, provided your disconnected slicer looks like 


    1) Create a measure that captures the selected value from your disconnected slicer

     

    SelectedChain = SELECTEDVALUE(dim_slicer[Value])
     
    2) On your main table, create a measure that acts as a flag to display 1 when the selected value is found within the column
     
    SelectFlag =

    var _sel = dim_slicer[SelectedChain]

    var _chain = MAX(DisconnectedSlicer[Value Chain])

    RETURN
    IF(CONTAINSSTRING(_chain, _sel), 1 , 0)
     
    This will give you the following result. When you've selected "IT", all rows within column "Value Chain" that have value "IT" will be assigned a value of 1.

    In the final step, add measure "SelectFlag" as a visual level filter to the table and set value to 1. This will show you only those rows that have values "IT"

     

     

    Kind regards,

    Rohit


    Please mark this answer as the solution if it resolves your issue.
    Appreciate your kudos! ğŸ˜Š

AFL's avatar
AFL
Frequent Visitor
3 years ago

Good afternoon,

 

I have a followup question to the above, if I may. I have gotten the original solution working as intended, many thanks for that. I am trying to modify the query a bit and have gotten stuck for quite a while now.

 

I have a main table containing the columns (amongst others):

 

  • [DATE]
  • [CLIENT]
  • [REP]
  • [TICKET ID]

 

I have a disconnected slicer which allows for the selection of the [TICKET ID], which is unique. The goal is to filter the main table by only showing those entries that share the same [DATE], [CLIENT] and [REP] as the row with the selected [TICKET ID] -> so show ALL [TICKET ID]s of the given [DATE], [CLIENT] and [REP].

 

I have tried using LOOKUPVALUE to retrieve the corresponding values from the other columns and then setting flags for them as well like in the given solution, but I seem to be fundamentally misunderstanding things about the interaction of filters.

 

Any help would be greatly appreciated.

 

Regards

Andreas 

AFL's avatar
AFL
Frequent Visitor
3 years ago

Never mind, I have finally got it. I guess at some point I had accidentally reconnected the disconnected slicer to the main table, which caused all sorts of headaches.