Forum Discussion
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 )
explain in detail and post a normal example
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.
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 )do you want to filter the column or get the whole value as one row or what?
