Forum Discussion
Calculating TOTALYTD skipping data
Make sure that the visual uses date and month from date table. And that the join between date table and sales table is single directional.
Also check these blogs/video for correcting time-intelligence:
Power BI — Year on Year with or Without Time Intelligence
https://www.youtube.com/watch?v=km41KfM_0uA
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a
Thanks for your suggestions, ChirgaGarg2512!
But that doesn't seem to be the problem, the cardinality is *-1 and cross filter direction is set on single. When there is no region selected it seems to be working fine.
It looks like it's skipping october and november but then in december it does accumulate the sales amount for october and november. Which would suggest that the measure is doing what it's suposed to do.
ChiragGarg2512Solution Sage
powerbi_genes The measure is not working correctly at all for the region filter, as the summition of data is wrong from february itself.