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
MFelix's avatar
MFelix
Super User
4 years ago

Hi  Anonymous ,

 

How are you calculating the FC% is it a column or a measure?

 

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Does this help?

     

     

     

    CRW Output 1 = IF([FP Mth]<[Current Mth]||[FP Yr]<[Current Yr], [Tech Avail Measure],[FC Availability % Value])

     

    Tech Avail Measure = AVERAGE('Scada Miner Availability (Client Agreed)'[Technical - Availability])

     

    Output 5 = IF([FP Mth]<[Current Mth]||[FP Yr]<[Current Yr],"Actual","Forecast")

     

    FC Availability % = GENERATESERIES(0, 1, 0.0001)