Forum Discussion

Lucy64's avatar
Lucy64
Advocate II
9 years ago

Help with Line Chart.

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?

 

Need Help

1 Reply

  • Sean's avatar
    Sean
    Community Champion
    9 years ago

    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' )
)