Forum Discussion
Matrix different subtotal row values
I have two tables. Table 1 contains a list of projects. For each project it contains amount spent, budget and percent of budget. Table 2 contains a list of project tasks. For each project tasks ...
VahidDM
Super User
Super UserHi Anonymous
I think these links will be helpful:
https://www.sqlbi.com/articles/clever-hierarchy-handling-in-dax/
https://www.vahiddm.com/post/why-my-measure-returns-the-wrong-total
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
Thanks, that's interesting but doesn't really accomplish what I'm wanting to do.
I ended up just creating two tables one showing the project values and one showing the individual task values. Not really what I wanted but it filled the need.