YTD total is right but value for each row is wrong

[martaredondo]

Hi there,

I have created a measure to calculte YTD debits like this: 

YTD Account Debits = TOTALYTD(SUM(vwOPEX_REPORTING[Account Debits]),vwOPEX_REPORTING[Date])

When I put this measure into a table, the total YTD Account Debits provides the right value but the value in each row are wrong:

Does anyone know why this happens?

I apreciate your help!

Thanks,

Marta

[amitchandak · Accepted solution]

You are using a date from your fact vwOPEX_REPORTING. It means when you view by Account, you might have few dates missing for few accounts. And if there are missing dates the time intelligence function might not give the correct results. 

Please create a separate calendar and use it

https://docs.microsoft.com/en-us/dax/calendar-function-dax

https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions