Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago
Solved

Matrix per user

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.

  • Anonymous's avatar
    Anonymous
    2 years ago

    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

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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