Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
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.
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!
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 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.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |