Problem with visual filter on multiple tables

[PowerBiNovice99]

I have a report that has three different data tables.

Within the main table there are individual transactions that all have a category A and B. Multiples transactions for each category.

I have two secondary tables that additional information on category A and B and again multiple records for each category.

I have created two additional tables that give me unique values for all the items in category A and B

Everything correctly connects up in the relationship manager.

I have cards that apply visual totals to the transactions from the main table when the user selects either something from category A or B in other visuals. These are all based off the main table.

I have tried to add cards that give a single number based on data in other tables. However this card only shows the total rather than filtering based on the selection of category A or B.

I would like this to change based on what the user has selected in other visuals

[v-yuezhe-msft]

@PowerBiNovice99,

Please check the following steps to troubleshoot this issue.

1. Change the Cross filter direction ftom Single to Both between TARGETS table and Brokers table.


2. Click other visual, enable "Edit interactions" , then make sure that you choose Filter for the Card visual.



If the above steps don't help, please share dummy data of your table and post expected result.

Regards,
Lydia

[PowerBiNovice99]

Sorry should have said that most of my visuals are based on the table cc_data and trying to get a card that sums the relevant categories from the table target based on what has been selected in the other visuals

[BalaVenuGopal]

Hi @PowerBiNovice99 ,

Could you pleae provide data diagram with example what you need

[PowerBiNovice99]

[img]https://preview.ibb.co/c4HYCn/PowerBI.png[/img]

[PowerBiNovice99]

I have a report that has three different data tables.

Within the main table there are individual transactions that all have a category A and B. Multiples transactions for each category.

I have two secondary tables that additional information on category A and B and again multiple records for each category.

I have created two additional tables that give me unique values for all the items in category A and B

Everything correctly connects up in the relationship manager.

I have cards that apply visual totals to the transactions from the main table when the user selects either something from category A or B in other visuals. These are all based off the main table.

I have tried to add cards that give a single number based on data in other tables. However this card only shows the total rather than filtering based on the selection of category A or B.

I would like this to change based on what the user has selected in other visuals

[PowerBiNovice99]

I have a report that has three different data tables.

Within the main table there are individual transactions that all have a category A and B. Multiples transactions for each category.

I have two secondary tables that additional information on category A and B and again multiple records for each category.

I have created two additional tables that give me unique values for all the items in category A and B

Everything correctly connects up in the relationship manager.

I have cards that apply visual totals to the transactions from the main table when the user selects either something from category A or B in other visuals. These are all based off the main table.

I have tried to add cards that give a single number based on data in other tables. However this card only shows the total rather than filtering based on the selection of category A or B.

I would like this to change based on what the user has selected in other visuals