topic Re: Calculate cost price for the whole year based on "Calendar[Year]", not by other date slicers in DAX Commands and Tips

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

PMY1965 — Tue, 04 Jun 2024 06:51:37 GMT

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])) )

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

sjoerdvn — Tue, 04 Jun 2024 08:01:35 GMT

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]))

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

PMY1965 — Wed, 05 Jun 2024 02:57:57 GMT

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