I am very close to achieving a successful pareto chart however i am missing something and it is causing a problem for me.
Here is my data:
What I am trying to achieve is a pareto chart to show the duration hours vs the room number.
The DAX for TotalAmount = SUM(ENGINEER_TABLE[DURATION_HOURS])
The DAX for Cumulative Percent = [DURATION_HOURS] / [TotalAmount].
Here is the graph at the minute:
As you can see it is calculating the percentage total correctly... however why is it not to 100 percent at the right hand side?
Please help, Thanks!