Forum Discussion
filter a table using the selected value from another table
I have a table that contains
| ID | Category |
| 1 | A |
| 1 | B |
| 2 | C |
| 3 | A |
| 3 | B |
| 4 | C |
| 4 | D |
| 4 | A |
| 5 | B |
I have another table that is setting as a filter in the entire page, which is generating a value of Category. I would like to create a table that shows me number of ids per category of selected value of a category from another table.
Currently I created a table, category and count of ID
A 3
B 3
C 2
I would like this above table to show only the value selected in other table filter. For example if A is selected, that the above table should show
A 3.
Currently I created a category = selected value (another category table)
But this formula is stating false when one id is under two categories.
I figured out myself Filtered Category Count =
VAR SelectedCategories = VALUES('ID category filter'[Category])
RETURN
CALCULATE(
DISTINCTCOUNT('ID and category'[ID]),
FILTER(
'ID and category',
'ID and category'[Category] IN SelectedCategories
)
)
