To stop automatical accumulated percentage column

[JohnnyK]

Good day.

Simple data of 2 tables as below, and I want to display them in bars side by side.

I added a slicer using the month. One of the bars (data of percentage) is automatically accumulated (exceeding 100%), when the two percentage columns are of the same setting. It seems the problem lies in the Month in use but I can't figure it out.

Any help, please? Thank you.

.pbix is here: https://gofile.io/d/3XWybp

[mhossain]

Hello @JohnnyK 

Create at two more tables, using dax you can create automatic and dynamic tables--

Table1 - Get the unique Month from both tables, so this table will have just one column having unique months from both the tables.

Table2 - Get the unique Names from both the tables, so this table will have just one column having unique Names.

Now create relationship Table1 to your both orginal tables  based on Months (one to many)

Create relationship Table2 to your both orginal tables based on Names (one to many)

Now in slicer, x asix bring Values/dimentions from these two new tables.

Please let me know if above is making sense, I could not access your file.

[JohnnyK]

@mhossain, thank you for your help and details in steps. I've followed them, but the result's still the same .

Can you please have a look at  the .pbix file? Thank you.

file: https://gofile.io/d/3XWybp

[mhossain]

Unable to open the pbix, showing error, please re-upload and share

[JohnnyK]

@mhossainthank you for the follow-up. please find the file, https://gofile.io/d/3XWybp

[mhossain · Accepted solution]

@JohnnyK 

See attached pbix, you just needed to remove the old both side relationship and activate the new relationship.

Please let me know if this solves.

[JohnnyK]

@mhossainthanks again for your patience and help! it works! in the bar chart it needs the Names from the new table (not the old table).

wish you a good day!

[mhossain]

@JohnnyK 

Right, both the dimensions will come from the new tables, Glad it worked, have a great time.

[Ashish_Mathur]

Hi,

Write a measure to take the average of Bonus % and Sold %.

[JohnnyK]

@Ashish_Mathur, thank you. could you please advise the use of the measure (average of Bonus % and Sold %)?

[Ashish_Mathur]

Hi,

I believe your question has been answered.