Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
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
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
User | Count |
---|---|
92 | |
87 | |
77 | |
73 | |
68 |
User | Count |
---|---|
116 | |
107 | |
88 | |
65 | |
63 |