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 :
Go to 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
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.
View solution in original post
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.