FY data for each month

[KaroRoza]

Hi, 

please help on that as I still can not get results which I expect to see.
This is very simple one dataset. I have sales records for all months (now 1-2.2026) and Targets for each month of 2026. I would like to have column in dashboard with Targets YTD and Target FY. I have troubles with FY Targets. There is also slicer with months.

I need to have a column which show FY value for each month ( to measure process agains full year, not only selected months).

Basically I need to see 310m for each month no matter how many months I select in slicer.

please help me on that,

many thanks,

Karolina

[Natarajan_M]

Hi @KaroRoza , I was able to recreate your scenario . 

Please find the details .


Sales :

Target :

Date:

Measure :

Sales YTD = SUM( Sales[Sales] )

Target FY =

CALCULATE(

    SUM( Targets[Target] ),

    REMOVEFILTERS( DimDate )

)

Target YTD = SUM( Targets[Target] )

Variance YTD = [Sales YTD] - [Target YTD]

All months selected :

Jan and feb as selection 

PBIX: 
Sales Target.pbix


Thanks 

If this response was helpful in any way, I’d gladly accept a kudo.
Please mark it as the correct solution. It helps other community members find their way faster

[JamieHolding]

Target FY = 
VAR SelectedYear = SELECTEDVALUE(Dates[Year], YEAR(TODAY()))
RETURN
CALCULATE(
    SUM(Targets[Annual Target]),
    ALL(Dates[Month]),
    Dates[Year] = SelectedYear
)

I'd suggest making a date table and then using a formula similar to the one here. The key is that you need to use ALL() to ignore the month filter.

[KaroRoza]

there is just one simple dataset with date column, month integer. There is no Dates table.

[KaroRoza · Accepted solution]

finally I found solution by mysleft

BP26 GOR USD FY =

    SUMX(ALL(DATABASE),DATABASE[BP26 GOR USD])