Insert Percentage column based on Month Number

[mollig3]

Hello, I have a table that looks like the one attached. I want to add an additional column that will spit out a number for the total time divided by the total for that month. For example in the first row, I would want the new column to be 7089/65075 (sum of all total times for month number 1). Thank you!

[AlB · Accepted solution]

Hi @mollig3 

Is what you show a table or a table visual? Do you want a calculated column or a measure?

Are the fields Total_time_c and Job Type measures? Are they summarizations of the fields or just the plain values? You'd need to give more details.

If it is what I think it is, you can create a measure like:

Measure =
DIVIDE (
    SUM ( Table1[Total_time_c] ),
    CALCULATE (
        SUM ( Table1[Total_time_c] ),
        ALLEXCEPT ( Table, Table1[MonthNrR.] )
    )
)