Forum Discussion

Joak's avatar
Joak
Frequent Visitor
9 years ago
Solved

Filter report with multiple tables

Hello everyone,    I have a problem on establishing a relation between two tables. I have understood how to link two tables with unique values, but here I want to link two table only to be able to ...
Need Help
Tips and Tricks
  • bullius's avatar
    bullius
    9 years ago

    Hi Joak,

     

    Are the Client Types the same in both tables?

     

    If so, try this:

    Create a new table using the SUMMARIZE function, e.g.

    SUMMARIZE ( 
    Table A,
    [ClientType]
)

    This will give you a table with unique values for ClientType, which you can use to filter both original tables.

     

    This is a brief description, let me know if you have difficulties. 

  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago

    Create a third table of unique client id's and relate it to both tables.

bullius's avatar
bullius
Helper V
9 years ago

Hi Joak,

 

Are the Client Types the same in both tables?

 

If so, try this:

Create a new table using the SUMMARIZE function, e.g.

SUMMARIZE ( 
    Table A,
    [ClientType]
)

This will give you a table with unique values for ClientType, which you can use to filter both original tables.

 

This is a brief description, let me know if you have difficulties.