Forum Discussion
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: ...
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.
To make your legend you used the category from data table or category table?
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.
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