Percentages of each hour by hour

[ipon70]

I have a matrix as seen in the picture.  I know I can change the matrix to show me a percentage of the column but I would like/need a measure that can actually do the math.

Example: At 1:30 AM I have a total of 721 items to count.  A 191 of those items were counted at 12:00am and 143 counted at 12:30 AM.  I need to know the percentage each shift counted.

Effectively I need 191/721 and that percentage, but I need that to work on a regular table not a matrix.

Thank you for any help.

[Syndicate_Admin]

Mark it as a solution in case anyone else needs it!

[Syndicate_Admin · Accepted solution]

good

What you have to do is generate a measure that divides those numbers that you indicate using an all for the denominator...
Kind of
Measure =
VAR _numerador = TotalElements
VAR _denominador = CALCULATE(TotalItems, ALL( HOURS ) )
RETURN
DIVIDE(
_numerator
_denominator

0)
What the ALL should do is keep the 721 saved and divide the rest of the numbers with the total for each hour

[ipon70]

I had to modify it slightly but this worked, thank you so much.