Calculate cost price for the whole year based on "Calendar[Year]", not by other date slicers

[PMY1965]

Hi there,

I have this measure to calculate my Cost Price for the whole year, based on the slicer  "Calendar[Year]". I do have many other date slicers.  I still only get the value for the month selected "Calendar[Month]", not the whole year. Please help.

Note:  I edited my formular , sorry for my previous one.

CostPriceForThisYear = CALCULATE( SUM('GL_LedgerTrans'[Credit]), FILTER( ALLSELECTED('GL_LedgerTrans'), 'GL_LedgerTrans'[OffsetAcctID-3] = "632" && 'GL_LedgerTrans'[AccountID-4] = "1541" && YEAR('GL_LedgerTrans'[TransDate]) IN values('Calendar'[Year]) ), REMOVEFILTERS('Calendar'), KEEPFILTERS(VALUES('Calendar'[Year])) )

[PMY1965]

Wow, it works.  You are so amazing. Thank you very much. My day is brighter now.

[sjoerdvn · Accepted solution]

Hard to say without more info on your report and especiallly the sematic model relationship, but if there is an active relationship between that fact table and the Calendar table, try something like:

CostPriceForThisYear = CALCULATE( SUM('GL_LedgerTrans'[Credit])
	, 'GL_LedgerTrans'[OffsetAcctID-3] = "632" 
	, 'GL_LedgerTrans'[AccountID-4] = "1541"
	, ALL('Calendar')
	, VALUES('Calendar'[Year]))