Help with Line Chart.

[Lucy64]

I am using a line chart to show manpower required for future projects.  I would like to incorporate a line which shows current manpower.  Which is a field not currently used in the chart (EmployeeCount).  I would like it to show like the Constant Line I added.  Can this be done?

[Sean]

What does the Employee count column represent?

We need to know what kind of aggregation to perform on it?

Generally your formula should look something like this...

Total Employees =
CALCULATE (
    DISTINCTCOUNT ( 'Table'[EmployeeID] ),
    ALLSELECTED ( 'CalendarTable' )
)