Apply Filter with multiple values

[armand453]

Hello, I am trying to apply a filter on a table with values of another table column, I have tried this formula with no sucess :

Formula = sumx(CALCULATETABLE(Table1; Table1[Category] = DISTINCT(Table2[Cat])); Table1[Value])

My tables are :

Table 1

CategoryValue

1	5
2	10
3	15
4	20
5	25

Table 2 

Cat

1

2

3

[Anonymous · Accepted solution]

@armand453 Please try below measure.

 First I created a table for unique categories. go to modeling tab and click on new table

Categories = VALUES('Table'[Category])

then create a measure

Measure = 
VAR _selectedCategories = VALUES(Categories[Category])
RETURN CALCULATE(SUM('Table'[Value]),FILTER('Table','Table'[Category] IN _selectedCategories))

Using category value from categories table in slicer and based on the selected values returning sum.

If it solved your purpose mark it as solved.

[Anonymous]

Column = LOOKUPVALUE(Table1[Value],Table2[Cat],Table1[Cat])

Create new measure on it to sum the values.