Forum Discussion
arp2
Helper II
Helper IIWeekly 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
Community Champion
Community Championarp2 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]))
arp2Helper II
Helper IIGreg_Deckler This solved the issue and thank you very much for the help.