Forum Discussion

bharosha's avatar
bharosha
Helper I
1 year ago
Solved

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, wh...
  • bharosha's avatar
    bharosha
    1 year ago

    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

            )

        )

bharosha's avatar
bharosha
Helper I
1 year ago

Here are some screenshots of what I have for dummy data and what I want to get out of. currentlydesired

v-menakakota's avatar
v-menakakota
Community Support
1 year ago

Hi  bharosha  ,
Thanks for reaching out to the Microsoft fabric community forum. 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
How to provide sample data in the Power BI Forum - Microsoft Fabric Community

 

If I misunderstand your needs or you still have problems on it, please feel free to let us know.   

Best Regards, 
Community Support Team