Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
Solved! 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
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.
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
27 | |
13 | |
11 | |
9 | |
6 |