Solved: Multiple Table Relationships

seangovind · ‎07-10-2020

Hi all,

Happy Friday! I'm having a bit of difficluty with a bar graph visual I'm working on. I'm relatively new to Power BI and I believe my issue is stemming from my table relationships. What I am trying to do is take the total count of each error and show it onto a bar graph split by each error description (please see the first screenshot for the erros). The issue I'm having is that the bar graph is totaling the count onto one description, in this case 'date', instead of splitting it up to 4 for 'date' and 1 for 'Slins'. The measure I have on the bar graph is totaling on the count for 'Errors 1', 'Errors 2', and 'Errors 3'. The 3rd screenshot is the relationships I currently have. Because the errors are separated into 3 columns, I had to figure out a way to have each related somehow so I made 3 separate tables and had those connected to a master table with each description in it. If you need me to provide any other additonal information please let me know. Any help would be greatly appreciated, thanks!

Anonymous · ‎07-12-2020

Hi @seangovind,

I'd like to suggest you unpivot your error fields to convert them to attribute and value, then you can create a simple relationship mapping tables and do calculations across multiple error fields.

Unpivot columns (Power Query)

Regards,

Xiaoxin Sheng

View solution in original post

Anonymous · ‎07-12-2020

Hi @seangovind,

I'd like to suggest you unpivot your error fields to convert them to attribute and value, then you can create a simple relationship mapping tables and do calculations across multiple error fields.

Unpivot columns (Power Query)

Regards,

Xiaoxin Sheng

seangovind · ‎07-15-2020

@Anonymous Thank you so much that worked perfectly!

parry2k · ‎07-10-2020

@seangovind it is surely the modelling issue, I would recommend to create sample pbix file non-sensitive data and share it. Also, make sure to share any data file you use in the report, it will help to model it correctly and solve your problem.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

seangovind · ‎07-12-2020

Good afternoon,

I actually am not too sure how to share the files on here, but I see a link to your email, so I will shoot you an email containing them.

Thank you so much!

Sean Govind

parry2k · ‎07-12-2020

@seangovind you can share using one drive/google drive.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.