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
You try the following methods.
Table:
Table 2 = CALCULATETABLE( VALUES('Table'[Category]),FILTER('Table',[Type]="T1"))
Measure = IFERROR(SEARCH(SELECTEDVALUE('Table 2'[Category]),SELECTEDVALUE('Table'[Category])),-1)
Please check whether the result of this time meets your expectation?
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 ,
Thanks for your solution. It's near to complete. I want to show these categories in the bar chart along with their values as I mentioned in the post.
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.