TOTALYTD not showing results if there's no Year filter

[Omezquita2]

I'm calculating Actuals/Forecast YTD and TOTALYTD is not showing the result for Actuals when there's no YEAR filter.

See below:

Here's the file: https://drive.google.com/open?id=1j5YqaB-tmleLZYRaMpzyM86FaEyVWjzj

Thanks!

[v-yuta-msft · Accepted solution]

@Omezquita2 ,

You may create measure YTD in Data table, not in measure1 table as below:

YTD = TOTALYTD(sum(Data[Value]), Data[Attribute])

  

Community Support Team _ Jimmy Tao

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

[v-yuta-msft · Accepted solution]

@Omezquita2 ,

You may create measure YTD in Data table, not in measure1 table as below:

YTD = TOTALYTD(sum(Data[Value]), Data[Attribute])

  

Community Support Team _ Jimmy Tao

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

[Omezquita2]

@v-yuta-msft  Thanks!

Why this is happening?

My understanding is that time intelligence functions should use a date column from a DateTable. That's why I'm using the date field from the DateTable.

[Omezquita2 · Accepted solution]

Got the answer!

TOTALYTD needs a date filter context to produce results. Since there's no filter context it was taking the last date from the date table. 

The last date in the Date Table is 2020 for which there are no Actuals, hence no results. When you put the Date from the Fact Table the combined filter context of Actuals + Date was for 2019 which contains data.

Thanks!

[v-yuta-msft]

@Omezquita2 ,

Great to hear that.

Regards,

Jimmy Tao