Total percentage doesn't add up to 100% in bar chart

[lyao716]

Hi,

I have data 'count([customerID])', and I want to show that in % by [product category]. Like the screenshot shows. However, the % doesn't add up to 100%. What kind of measure I can use to fix this?

Thank you in advance.

BR,

Lin

[v-yiruan-msft · Accepted solution]

Hi @lyao716 ,

You can create a bar chart with the same setting as the one in below screenshot, please find the details in the attachment.

If the above one is not what you want, please provide some sample data with Text format and your expected result with more details(include calculation logic, special examples, screenshot etc.). Thank you.

Best Regards

[Nathaniel_C]

Hi @lyao716 ,

You will probably need to use ALL() or ALLSELECTED().  Perhaps you might be able to dummy up some data to create a pbix or share your pbix with us.

https://www.youtube.com/watch?v=1KfTmRYRLZs orhttps://docs.microsoft.com/en-us/dax/allselected-function-dax might be useful.

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel


Please read this post to get your question answered more quickly:

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Nathaniel