Forum Discussion

Dhruvan's avatar
Dhruvan
New Member
2 years ago
Solved

DAX

How to get all values based on selected values for example : if we select "150" then we need to get all related values with "15" using DAX 

  • Hi Dhruvan, here is DAX solution. However I personally prefer to go for "Text Filter" visual suggested by mlsx4 . Good luck!

     

    Partial search measure = 
    VAR _FullSearchTerm = SELECTEDVALUE( 'Selected value'[Column1] )                //here we capture selected value, remember that only 1 value at a time should be selected, otherwise use iferror argument of SELECTEDVALUE()
    VAR _NumberOfCharactersToSearch = 11                                            //change number to change number of characters you're interested in
    VAR _RealSearchTerm = LEFT( _FullSearchTerm, _NumberOfCharactersToSearch )      // Assumption: first N left characters
    
    RETURN 
        IF(
            CONTAINSSTRING( 
                SELECTEDVALUE( 'Related value'[Column1] ),
                _RealSearchTerm
            ),
            1,
            0
        )

     

9 Replies

    • Sergii24's avatar
      Sergii24
      Super User

      Perfect! Remember to mark a preffered answer as a solution to help others easily find it 🙂

  • mlsx4's avatar
    mlsx4
    Memorable Member

    Hi Dhruvan 

     

    Can you share an example of what you have as data and what to do you try to achieve?

    • Dhruvan's avatar
      Dhruvan
      New Member

      Hi mlsx4 ,

      Selected value part - 500-453674-599

      Related value part - 500-453674-600,500-453674-601,500-453674-588,500-453674C599,500-453674D597.

      So when select the mentioned value(500-453674-599) ,we should get all the values related to it as shown in the example.

      • Ahmedx's avatar
        Ahmedx
        Super User

        explain in detail and post a normal example