Forum Discussion

Maddyqc's avatar
Maddyqc
Frequent Visitor
6 years ago
Solved

Not able to filter

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

 

Need Help
  • edhans's avatar
    edhans
    6 years ago

    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. 

4 Replies

  • edhans's avatar
    edhans
    Icon for Community Champion rankCommunity Champion
    6 years ago

    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. 

      • edhans's avatar
        edhans
        Icon for Community Champion rankCommunity Champion
        6 years ago

        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?

  • Tahreem24's avatar
    Tahreem24
    Icon for Super User rankSuper User
    6 years ago

    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.