Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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.   ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Appreciate some help with this one, i need a soution asap

  • MFelix's avatar
    MFelix
    Super User
    4 years ago

    Hi 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.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Output 5 is giving me "Forecast" or "Actual" months, CRW Output 1 is giving me the % of availability, its this measure that i need to average of and its using the 2 % figures as per below

       

      FC Availability % is coming froma  generated series, Actual Availability if coming from Tech Availability

       

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Average should be 68.93%

       

      97.95 
      88.25 
      96.49 
      96.70 
      95.86 
      96.6095.31
      42.56 
      42.56 
      42.56 
      42.56 
      42.56 
      42.56 
       68.93