Forum Discussion
Solved
Weekly Forecast and capcity Chart
I have a table showing multiple disciplines names, week date and number of employees in discipline for that week. I want to plot this in secondary Y Axis in column line combo chart but it’s sum...
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]))
Greg_Deckler Got that! I tried but I am unable to solve it. Can you plz have a look at PBI dummy? https://1drv.ms/u/s!Ag_LqrJ6gGmfllbA6ZrdJLdiGkQL?e=WEvQwb
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]))
Greg_Deckler This solved the issue and thank you very much for the help.