but this does not allow me to filter on a specific employee when I try to create a table, since my measure only shows the total number of employees per year..
SUMX of the distinctcount of employees also does not work because I want to display the overall number of employees by each type of description. If I use SUMX, the calculation filters based on the description and does not give the total employees for each description.
Is there another formula I can use to allow me to display the total employees for different descriptions but also allow me to filter for how many days a specific employee worked/year?
Please let me know if there is anything I can clerify