Multiple Table Relationships

[seangovind]

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!

    

[v-shex-msft · Accepted solution]

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]

@v-shex-msft Thank you so much that worked perfectly!

[parry2k]

@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.

[seangovind]

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]

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

[seangovind]

I uploaded the files to Google Drive and the link is below. Please let me know if you have any trouble opening the link. Thanks!

https://drive.google.com/drive/folders/1owKP8snAk3KPnWmXxfp4tKo-_Gxl3jyE?usp=sharing