Forum Discussion

baronraghu's avatar
baronraghu
Helper III
2 years ago

Filter two tables

HI All,   I have Three Tables  Table 1 State Uttar Pradesh Punjab Tamil Nadu Kerala   Table 2     State City Population Uttar Pradesh Lucknow 170248 Punjab Mo...
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Thanks for the reply from MFelix , please allow me to provide another insight: 

Hi  baronraghu ,

 

Here are the steps you can follow：

Create calculated table.

Table =
SUMMARIZE(
    'Table2',[City],[Population],
    "Customers",
    SUMX(FILTER(ALL('Table3'),
    'Table3'[City]=EARLIER('Table2'[City])),[Customers]))

You might also consider creating measure：

Measure =
SUMX(
    FILTER(ALL('Table3'),
    'Table3'[City]=MAX('Table2'[City])),[Customers])

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly