Find the percentage Based on the selection of month value and Total of month value

[Anonymous]

I Have a table name called KPI . this table having  two following column 

Month      SLA KPI    

January      63

Febuary     63   

Total SLA KPI  Sum 126 .   but i want find the percentage seperate  Month wise and  total of Month value .

January  Month SLA KPI / January Month total 

=63/63 => 100%

looking for support . thanks in advance 

[Anonymous]

@FreemanZ  thank you so much .it's working 

[FreemanZ · Accepted solution]

hi @Anonymous 

try to add a calculated column like:

Column =
DIVIDE(
    [SLA KPI],
    SUMX(
        FILTER(
            TableName,
            TableName[Month]=EARLIER(TableName[Month])
        ),
        TableName[[SLA KPI]]
    )
)