Row level Sum and Problem with Donuts. Please Help!

[Anonymous]

I have a problem that I'm sure is coming down to a row level summation or something.

I am calculating some measures and columns: Enabled, Disabled, Idle Time, Not Running2 , Not Running Donut

Average Run Time =

AVERAGEX(

    KEEPFILTERS(VALUES(Table[Date])),

    CALCULATE(sum(Table[Run Time])/DISTINCTCOUNT(Table[device_name])))

Enabled = if([status] = "PRR", CALCULATE((Table[Average Run Time]/86400),Table[status]="PRR"),0)

Disabled = if([status] = "PNR", CALCULATE((Table[Average Run Time]/86400),Table[status]="PNR"),0)

Idle Time = SUMX(

    KEEPFILTERS(VALUES(Table[Date])),

    CALCULATE(if(SUM(Table[Run Time])> 86400, 0, 86400-SUM(Table[Run Time]))))

Not Running 2 = [Idle Time]

Not RunningDonut = [Not Running 2]/86400

When I make a donut using the above I get the correct Numbers.

Here the total of enabled and disabled is 707. If i calculate it using a column by [Enabled] + [Disabled], i get the correct value. The value of Not Running(Not RunningDonut) here is 60.

When I try to add this as [Enabled]+[Disabled]+ [Not Running] , i expect to get a value as 767, but instead get 6,190.

Please help!! I know the values in the donut are right because if I filter and manually validate by every single device, it shows the right value. Please advise!! I am new to powerBI and cant seem to figure out what im doing wrong

[v-chuncz-msft]

@Anonymous,

The requirement is not very clear. You may check if this post helps.