Forum Discussion
Weekly Forecast and capcity Chart
arp2 Updated your PBIX, attached below signature. Your Week to Week relationship is inactive so you need to use USERELATIONSHIP in a measure.
Projected Capacity Measure = CALCULATE(SUM('Table2'[Projected Capacity]), USERELATIONSHIP(Table1[Week], 'Table2'[Week]))
6 Replies
arp2 Generally this means that there is a missing relationshp in the model.
The dummy PBI file is available at following link.
https://1drv.ms/u/s!Ag_LqrJ6gGmfllbA6ZrdJLdiGkQL?e=WEvQwb
What's happening is, when I add Capacity/Projected Capacity to secondary Y axis, it is summing the value for selected discipline for all weeks in table and showing flat line (summed number) whereas I want weekly number in the chart
arp2 Right and I'm saying that is generally because there is a missing relationship between 2 tables and thus all of the rows in that second table are in context versus being filtered to the correct rows via the relationship.
