Not able to filter

[Maddyqc]

Hello,

As you can see, I am a newbie here. I am trying to make a table with tota cases (total rows) and total deaths in the same table. When I make separate tables, it works. When try to have them in the same table, it doesnt work. Your inputs are sincerely appreciated. Thank you

[Tahreem24]

Are you using values from two different tables and try to put them in the same table visuals? If yes, so  check the relationship between those table.

[edhans · Accepted solution]

It is your data model. One of those tables isn't filtering the other. You can turn on crossfiltering by using something like this:

TEST =
CALCULATE(
    SUM( table2[field] ),
    CROSSFILTER ( table1[key], table2[key], BOTH )
)

But the fundamental issue is your model. You should have a star schema where your field in the table should be from a DIMENSION table that is filtering both of these FACT tables vs having the FACT tables filter one another. 

[Maddyqc]

Thank you, edhans.

[edhans]

Great @Maddyqc - can you please mark the respons as the "solution" so the thread can be marked done and future community users can see the solution that worked?