Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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
Solved! Go to 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
)
Thanks to all, it worked successfully.👍
Perfect! Remember to mark a preffered answer as a solution to help others easily find it 🙂
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.
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.
do you want to filter the column or get the whole value as one row or what?
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
)
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
85 | |
82 | |
69 | |
49 |
User | Count |
---|---|
143 | |
123 | |
107 | |
61 | |
55 |