Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Relationship Between two tables

Hi team,   I have two tables. Table A contains the count of registrations country wise and Table B contains Total number of usres. I have divide the sum of registrations with the sum of to total re...
Need Help
  • johnt75's avatar
    johnt75
    4 years ago

    Create a new table with all the countries in, like

    Countries = DISTINCT( UNION(
ALLNOBLANKROW('Table 1'[Country]),
ALLNOBLANKROW('Table 2'[Country])
))

    then create one-to-many relationship from the new table to both existing tables. Use the column from the new table in your visuals.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi johnt75

 

Thanks a lot. That helped me solved my problem Thank you.

 

Regards