Forum Discussion
Solved
Apply Filter with multiple values
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(T...
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.
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.
Column = LOOKUPVALUE(Table1[Value],Table2[Cat],Table1[Cat])
Create new measure on it to sum the values.