Forum Discussion
filter table based on selected value using contains
Hi, Anonymous
You can try the following methods.
Table 2 = CALCULATETABLE( SUMMARIZE('Table','Table'[Category],'Table'[Value]),FILTER('Table',[Type]="T1"))The view on the left is obtained from Table 2. Other settings remain unchanged.
This is the relevant document, hope to help you:
https://docs.microsoft.com/dax/search-function-dax#example-error-handling-with-search
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, Anonymous
Please check the following methods.
Measure = IFERROR(SEARCH(SELECTEDVALUE(Category[Category]),SELECTEDVALUE('Table'[Category])),-1)Put Measure in Fliters and set not equal to -1.
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi v-zhangti
Thank you for your reply. But I don't have any category table.
Is it possible to create the category table on the run and then use the above measure?Hi, Anonymous
So where does your A B C D come from?
Best Regards
Here's my main sample dataset:
I am using this to create a chart by setting up the Type filter to T1.