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