Percentage per month calculation

[Palen]

Hi All, 

I have a table which tracks how many records an employee works on. I have a slicer which applies time periods to the table. 

Eg) Slicer is June 2024

Table:

Person A: 3 items (by distinct count of ID)

Person B: 3 items (by distinct count of ID)

Person C: 4 items (by distinct count of ID)

How do i create a measure which will return 30% for person A and B and 40% for person C. The measure must update if the slicer changes. I am basically trying to achieve the following:
%per member = items per member(in month)/total number of items(in month)

[sjoerdvn · Accepted solution]

You haven't shared anything about your model, but it should look something like below.

% per member = DIVIDE(
  DISTINCTCOUNT(fact_employee_work[ID])
  ,CALCULATE(DISTINCTCOUNT(fact_emloyee_work[ID]), ALL(dim_employee))
)