Forum Discussion
Measure % Total not correct
Im trying create a visual that dispays actual % of availability with the option to change the furture FC availability % to then calculate the projected availability over a defined 12 mth period. ...
MFelix
Super User
Super UserHi Anonymous ,
In the Output 5 you need to have the average of the values selected above is that correct in this case would be 69.19% correct?
Try the following calculation:
Output 5 average = AVERAGEX(VALUES(FinCalendar[YearMonth]), [Output5])The Table[YearMonth] must be a column on your finCalendar if you don't have it please add it.
If that does not work please get back to me.
Average should be 68.93%
| 97.95 | |
| 88.25 | |
| 96.49 | |
| 96.70 | |
| 95.86 | |
| 96.60 | 95.31 |
| 42.56 | |
| 42.56 | |
| 42.56 | |
| 42.56 | |
| 42.56 | |
| 42.56 | |
| 68.93 |