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! ğŸ˜Š

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

pmay , You can use containsstring or search, but when you select more than one value that will be a big challenge

 

example

countrows(filter(Table, search(selectedvalue(Value[Value]) , Table[Value],,0)>0)) 

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

Thank you for taking the time to try to help.

 

I'm OK with limiting to Single Select (or All).  


Your measure would return me a count of the rows, but I don't need a count, I want all the values in all the columns.  There are actually a bunch more columns, but I guess the logic will be the same regardless (if it's possible at all).
I can make it work for a single value, easily enough:

SLA 1 Month Span (SelectedValueOnly) = CALCULATE([SLA 1 Month Span], FILTER('Service Portfolio', CONTAINSSTRING('Service Portfolio'[Value Chain], SELECTEDVALUE('DIM Value Chains'[Value Chain]))))