Measure % Total not correct

[Anonymous]

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.

Im using a generated series for the FC and the actuals are in a differnet table. Problem i have is that the total average % is not correct and only appears to be showing the FC % figure?

Appreciate some help 

[Anonymous]

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

[MFelix]

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]

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

[Anonymous]

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

[MFelix]

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]

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)