Power BI: Bar chart with percentage

Question

I need to get a bar chart that displays percentages based on the simple division of 2 values. See below:

The calculation should be 'Services / Sum of Accounts' to get my %. (116,713 / 121,756 = 0.9585 [or 95.9%])

I have tried using Quick Measure, but I can't seem to get it to do what I want. I come from a background of SSRS, but the way PBI works appears to be different enough that I'm not sure how to accomplish this otherwise simple operation. Much thanks!

Answer 1

You probably need to write your own measure. You can start with a quick measure and modify the formula or create one from scratch.

I don't know what your data looks like but it might be something like

SUM(Table[Services]) / SUM(Table[Accounts]).