Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Palen
New Member

Percentage per month calculation

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)

 

1 ACCEPTED SOLUTION
sjoerdvn
Super User
Super User

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

 

View solution in original post

1 REPLY 1
sjoerdvn
Super User
Super User

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

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.