topic Re: Total percentage doesn't add up to 100% in bar chart in DAX Commands and Tips

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

Anonymous — Tue, 23 Nov 2021 13:02:30 GMT

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

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

Nathaniel_C — Tue, 23 Nov 2021 15:30:18 GMT

Hi Anonymous ,

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

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

Anonymous — Fri, 26 Nov 2021 08:16:47 GMT

Hi Anonymous ,

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