Matrix per user

[Syndicate_Admin]

I have the following:
a measure that counts the boxes of each worker and I make a table per month for each one.

Now what I would like is to make another table like the one attached where for each worker I put the boxes of each worker (I already have it in the other table) and also another column with the % (boxes of the worker / total boxes)

I want this % column for each worker.

For example, for user 1 there are 51 boxes in January and the total number of boxes for all users, let's say it is 220
The % would be 51/220 = 23%
I have a measure that adds the boxes

TotalBoxes = COUNT(Cab_act_almacen_reg_sql[Whse_ Activity No_])

Thank you.

[v-heq-msft]

Hi @Syndicate_Admin ,
Here some steps that I want to share, you can check them if they suitable for your requirement.
Here is my test data:

Create a measure

Measure = 
VAR _SumOfBoxByMonthNo = 
CALCULATE(
    SUM('Table'[Box]),
    ALLEXCEPT(
        'Table',
        'Table'[Month.No]
    )
)
RETURN
SELECTEDVALUE('Table'[Box])/_SumOfBoxByMonthNo

Final output

Or another solution

Create measure

Count Box = COUNT('Table'[Month.No])

Result = 
VAR _sum = SUMX(ALLEXCEPT('Table','Table'[Month.No]),'Table'[Count Box])
RETURN
[Count Box]/_sum

Final output
 

Best regards,

Albert He

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