Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Hi again,
is there anyone who has a solution to this problem?
Many thanks in advance for your help!
BR
D
I already figured the image option out already, here is the sample data:
@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.
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!
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
95 | |
83 | |
70 | |
66 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |