DAX

[Dhruvan]

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 

[Dhruvan]

Thanks to all, it worked successfully.👍

[Sergii24]

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

[mlsx4]

Hi @Dhruvan 

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

[Dhruvan]

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]

explain in detail and post a normal example

[Dhruvan]

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 (The rows that matching to Prefix of the selected value)related to it as shown in the example.

[Ahmedx]

do you want to filter the column or get the whole value as one row or what?

[Sergii24 · Accepted solution]

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
    )

[mlsx4]

Hi @Dhruvan 

You can import from the store text filter visual. It does exactly what you need: