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

      The Category table. I guess the fact that there's no relationship between the two tables forces Power BI to calculate the measure on each of the categories.

      • MFelix's avatar
        MFelix
        Super User
        8 years ago

        Hi agent,

         

        Using your data and you setup and having the active relationship between data and category I got the correct result. Check the PBIX attach and see if you have something that isn't machthing in your model, maybe the way the relationship is setup.

         

        I also added a table with the the amounts and YTD calculations just to be sure everything was ok.

         

        Regards,

        MFelix