cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Patron
Post Patron

New Table and its relationship

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
1.PNG
2.PNG

 

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

rel.PNG

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

3.PNG

 



Regards,
Hari 




1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User IV
Super User IV

Re: New Table and its relationship

@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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
My Recent Blog -Week is not so Weak Connect on Linkedin

Proud to be a Super User!

View solution in original post

2 REPLIES 2
Highlighted
Super User IV
Super User IV

Re: New Table and its relationship

@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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
My Recent Blog -Week is not so Weak Connect on Linkedin

Proud to be a Super User!

View solution in original post

Highlighted
Community Support
Community Support

Re: New Table and its relationship

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.

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Power BI Desktop August 2020 Update

Power BI Desktop August 2020 Update

We have great updates this month! Click the link for the video with more info.

Top Solution Authors
Top Kudoed Authors