Forum Discussion

dading's avatar
dading
Icon for Helper II rankHelper II
6 years ago
Solved

calculate total hour

Hello all, i have table like this Date Eqmt Status duration_hour 01-Jan-20 E1 b 1 01-Jan-20 E1 c 5 01-Jan-20 E2 a 4 01-Jan-20 E2 b 4 02-Jan-20 E1 a 1 02-Jan-2...
Need Help
  • az38's avatar
    az38
    6 years ago

    Hi dading 

    try measure

    Total Hour per Eqmt = 
CALCULATE(SUM(Table[duration_hour]), ALLEXCEPT(Table, Table[Eqmt], Table[Date]) )

    then measure

    Status per hour = 
DIVIDE(SELECTEDVALUE(Table[duration_hour]), [Total Hour per Eqmt])
az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

Hi dading 

try measure

Total Hour per Eqmt = 
CALCULATE(SUM(Table[duration_hour]), ALLEXCEPT(Table, Table[Eqmt], Table[Date]) )

then measure

Status per hour = 
DIVIDE(SELECTEDVALUE(Table[duration_hour]), [Total Hour per Eqmt])
  • dading's avatar
    dading
    Icon for Helper II rankHelper II
    6 years ago

    Amazing....

     

    thank you az38