Forum Discussion

MorganKlaif's avatar
MorganKlaif
Icon for Helper I rankHelper I
2 years ago
Solved

Getting Percentage of Member Count Divided by Capacity Into Matrix Table

Hello.   I'm currently working on a report that can pull a distinct count of members registered for certain childcare programs, based on a date range of the month and year, which includes the perce...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi MorganKlaif ,

     

    According to your description, here are my steps you can follow as a solution.

    (1) Change the data type of the [2021-2022 Capacity] column.

     

    (2) We can create a measure. 

    Measure = DIVIDE(DISTINCTCOUNT('Program Registrations'[Customer ID]),SUM('Programs'[2021-2022 Capacity]),0)

    (3) Then the result is as follows.

    Best Regards,

    Neeko Tang

    If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

MorganKlaif's avatar
MorganKlaif
Icon for Helper I rankHelper I
2 years ago

Hi Anonymous,

 

It seems to work fine on the smaller test report, but when I transitioned it to my live and actual report, where there's a ton of data, it doesn't seem to be working correctly.

 

For example, with one branch, Greater Bergen, my 2021-2022 Capacity column is set to be 88 for that branch.

 

The Sept 2021 enrollments are 46, so the percentage should be 52%, but it's only showing as 7%. The Oct 2021 enrollments are 53, so the percentage should be 60%, but it's only showing as 9%. Here's what it looks like:

 

It seems that only the first branch of East Orange is working correctly.

MorganKlaif's avatar
MorganKlaif
Icon for Helper I rankHelper I
2 years ago

Anonymous,

 

Nevermind! I think I'm ok now. By changing SUM to MIN it's pulling in the correct %.