Forum Discussion
Calculating ITD?
Never mind, got it figured out. As counterintuitive as it would seem, I had to remove the relationship between the Data table and the Categories table.
Hopefully this helps someone else in the same boat.
When adding the filter CurrentCategory to your measure you are forcing the calculation to cgeck if the category exists on your table if not it won't return value try to remove the last part of the filter from your calculation being in the measure only the date filter.
Regards,
MFelix
Thanks MFelix. That doesn't quite work either. Here's how it looks if I take out the CurrentCategory filter:
- Hi agent,
Try to use the TOTALYTD formula:
Total = TOTALYTD (SUM(Data[Amount]); Datetable[Date])
Regards
MFelixThanks MFelix. It still doesn't work once the category breakdown is added. Here's what the TOTALYTD looks like without the category breakdown:
This looks fine - as expected. Once I add the category breakdown, it turns into this:
Any other ideas?
Never mind, got it figured out. As counterintuitive as it would seem, I had to remove the relationship between the Data table and the Categories table.
Hopefully this helps someone else in the same boat.