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,
In the Data Table itself, you should have a Master Category column with values of A,B,C and D. Now create your visual/slicers.
Ashish_Mathur I don't have the Master Column with values of A,B,C,D.
So if they are in another table then one can always bring them over into your table by using the RELATED() or LOOKUPVALUE() funcion.