Forum Discussion

agent's avatar
agent
Regular Visitor
8 years ago
Solved

Calculating ITD?

Hey everyone,   I'm having an issue calculating the ITD value of my dataset. It seems like it should be pretty simple but I can't get it to work properly. Here's what my sample data looks like:   ...
  • agent's avatar
    agent
    8 years ago

    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.

MFelix's avatar
MFelix
Super User
8 years ago
Hi agent,

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
  • agent's avatar
    agent
    Regular Visitor
    8 years ago

    Thanks MFelix. That doesn't quite work either. Here's how it looks if I take out the CurrentCategory filter:

     

     

    • MFelix's avatar
      MFelix
      Super User
      8 years ago
      Hi agent,

      Try to use the TOTALYTD formula:

      Total = TOTALYTD (SUM(Data[Amount]); Datetable[Date])

      Regards
      MFelix
      • agent's avatar
        agent
        Regular Visitor
        8 years ago

        Thanks 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?