Forum Discussion
Helper IVcompletion percentage
Good afternoon!
I am trying to get this percentage completion to work. The actual power and target power are sums of rows from the table they are attached to. I need the completion to be basically actual/target, but I can't seem to get it to work. Thanks in advance!
Ok so just to confirm the above is what your raw data look like?
Based on your description the following measure would work:
DIVIDE ( SUM ( TableName[Actual] ), SUM ( TableName[Target] ) )then set it to display as a percentage.
Have a suspision I might be missing something from your description though so do come back if it doesn't work.
4 Replies
- bcdobbs
Community Champion
Do you have existing measures for ActualPower and TargetPower or are you using implicit column measures?
If you can provide some dummy data and your table structure I'm happy to help.
nataliesmiy1357Of course here is some! So the Actual and Target in the screenshot above are sums of the month, but I need the completion of the total.
So the sum(actual) for the month / sum(total) for the month.
Month Actual Target January 14 29 January 28
40 December 12 12 December 43 80 February 13 25 February 5 10 - bcdobbs
Ok so just to confirm the above is what your raw data look like?
Based on your description the following measure would work:
DIVIDE ( SUM ( TableName[Actual] ), SUM ( TableName[Target] ) )then set it to display as a percentage.
Have a suspision I might be missing something from your description though so do come back if it doesn't work.
- nataliesmiy1357
I don't have any exisiting measures for this. Just using the data provided in the tables.