Mismatch between Table Visual and Card Visual

[Anonymous]

Hi ,

I have three Tables Table1, Table_Extension and CUSTOMRS .My requirement is to show a table with columns from three tables and to show total count in card visual .However if i filter based on date , i'm getting values in card visual (since taking count  from Table1]but there is no data in table ( columns coming from Table_Extension and CUSTOMRS have no data for selected date)

card visual - count([Table1[KEY])

columns used in Table - Table1[Account no],Table_Extension[Original Reference no],Table_Extension[Beneficiary Name],Table_Extension[Reference Name],CUSTOMRS[Remitting bank].

I should show card visual data as blank and i need to write expression so that it gets grouped by columns from Table_Extension and CUSTOMRS.Please help

[v-yalanwu-msft]

Hi, @Anonymous ;
Cards and tables are different contexts, tables have only one field, regardless of context, but tables have context, so sometimes the results are different

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.