New Table and its relationship

[harirao]

Hi All,

I have created new table having three columns as as per main table, but country slicer not giving correct result, below screen print for your reference.

Before creating relationship

Note: Reason for creating new table, missing subregion should reflect in matrix table.

After creating Relationship
Subregion for APAC should be 1, but getting total of APAC

Regards,
Hari 

[v-lionel-msft]

Hi @harirao ,

It may be caused by with the calculation formula of the two measures. Do you mind sharing your .pbix file?

Best regards,
Lionel Chen

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

[amitchandak · Accepted solution]

@harirao , if you are creating a new table to create a dimension then relation should be one to many.

If there is an issue with key column the create a combined column

Key = [Country] & " - " &[Region Group]& " - " &[SubRegion]

This Column in both tables and join on this