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.

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?

    • agent's avatar
      agent
      Regular Visitor
      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
        To make your legend you used the category from data table or category table?