Try to apply a monthly value as a yearly value in another calendar table

[saiko_cs]

Hello community,

I have a monthly fact table with two columns:

Date	Value
01/01/2023	232
01/02/2023	241
01/03/2023	245
01/04/2023	247
01/05/2023	244
01/06/2023	246
01/07/2023	244
01/08/2023	243
01/09/2023
01/10/2023
01/11/2023
01/12/2023

I calculate the ytd average with this measure:

CALCULATE(AVERAGE([Value]),DATESYTD('CALENDAR'[Date]))

The result is what I want: 

Date	Value	YTD Average
01/01/2023	232	232
01/02/2023	241	237
01/03/2023	245	239
01/04/2023	247	241
01/05/2023	244	242
01/06/2023	246	243
01/07/2023	244	243
01/08/2023	243	243
01/09/2023		243
01/10/2023		243
01/11/2023		243
01/12/2023		243

And I'm using a visual with a monthly slicer to show the result on a page.

On the same page, I also need to display a bar chart of the current year AND not be filtered by the monthly slicer.

So, I create a second calendar table to display each measures I need to show for each month of the current year.

But I can't find a solution to show a specific value in this visual.

Example 1:

If the monthly slicer filtered March 2023, my "YTD average" is 239.

I want to show as a yearly line with this value (239) for the whole year 2023.

Example 2:

If the monthly slicer filtered June 2023, my "YTD average" is 243.

I want to show as a yearly line with this value (243) for the whole year 2023.

Please advise,

[saiko_cs]

Thanks a lot, that's exactly what I try to find (thumb up)

[Anonymous · Accepted solution]

Hi @saiko_cs ,

I have created a simple sample, please refer to it to see if it helps you.

Create a measure.

Measure = 
AVERAGEX(FILTER(ALL('Table'),'Table'[Date]<=SELECTEDVALUE('Table'[Date])),'Table'[Value])

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.