comparing the measures from different tables (not linked directly)
Hi, So I have one table which has forecast at product-mkt level for different months & year. And I have another table where I have constrained forecast at the same level with an additional column of reasons as to why that forecasted sales cant be achieved with standard reasoning in each month-year. The tables are connected via hierarchy tables (& not directly)
Now I need to find the difference btw the regular forecast and the constrained forecast for each reason. When I subtract the SUM measures from those tables and view the difference in graph for different reasons, the data makes no sense. I guess its happening because the tabels are not linked directly. What is the best way to achieve this?
Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.