cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Omezquita2 Frequent Visitor
Frequent Visitor

TOTALYTD not showing results if there's no Year filter

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

See below:

TotalYTD Problems.PNG

 

 

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

 

Thanks!

2 ACCEPTED SOLUTIONS

Accepted Solutions
Community Support Team
Community Support Team

Re: TOTALYTD not showing results if there's no Year filter

@Omezquita2 ,

 

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

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

Capture.PNG  

 

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 Frequent Visitor
Frequent Visitor

Re: TOTALYTD not showing results if there's no Year filter

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!

4 REPLIES 4
Community Support Team
Community Support Team

Re: TOTALYTD not showing results if there's no Year filter

@Omezquita2 ,

 

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

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

Capture.PNG  

 

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 Frequent Visitor
Frequent Visitor

Re: TOTALYTD not showing results if there's no Year filter

@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 Frequent Visitor
Frequent Visitor

Re: TOTALYTD not showing results if there's no Year filter

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!

Community Support Team
Community Support Team

Re: TOTALYTD not showing results if there's no Year filter

@Omezquita2 ,

 

Great to hear that.

 

Regards,

Jimmy Tao