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

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