I have a table with two dimensions, store and year. I want to take a count of distinct employees at each store and calculate the percentage of employees at each store segmented by year. So in the table below, in 2018 store A had 6 of the total 17 distinct employees, which comes out to about 35%. I tried using the following expression: (Count(DISTINCT EMPLOYEES)/Count(TOTAL DISTINCT EMPLOYEES)), but the denominator is incorrect here because it returns a count of total distinct employees across all years.