Calculate an average of ACT and FC

[daveinitiv]

Hi all,

I would like to calculate a measure that dynamically calculates an average FTE value for a Mix of ACT and Forecast figures.

To display a Timeline of ACT and FC FTEs, I firstly created a measure (not linked to any table) called "Selection Type[Month]" that simply contains figures from 1-12.

When I add this as slicer, I can dynamically choose, up to which month Actuals are displayed, and from which month ongoing Forecast values.

Then, my FTE ACT/FC "timeline" measure is defined as follows:

FTE ACT/FC = if([Selection Type [Month]]]>=average(Date[Month]);[FTE_ACT];[FTE_FC])

Now, I would like to calculate a cumulativ average of this measure:

FTE ACT/FC Average = TOTALYTD(CALCULATE([FTE_ACT/FC] );Date[Date] ) / CALCULATE( TOTALYTD( DISTINCTCOUNT( Date[Month] );Date[Date] ) )

Unfortunately, it doesn't work, the calculated averages are always wrong.

Could you help me please?

I hope my request is clear, if you need additional info, please let me know

BR

daveinitiv

[daveinitiv]

Hi again, 

is there anyone who has a solution to this problem?

Many thanks in advance for your help!

BR

D

[daveinitiv]

I already figured the image option out already, here is the sample data:

[amitchandak]

@daveinitiv , difficult to say without looking at data and error in data.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[daveinitiv]

Hi,

I have created a sample file...how can I upload it? It says pbix is not supported..I cannot even upload an image of it.

Thanks!

[Anonymous]

@daveinitiv 

The image is the output visual. You can upload a sample pbix to Onedrive for business then share and post the file link. 

Regards
Paul