Divide Prior to SumX

hi jpaguiar 

try like:

Column =

VAR _table=

FILTER(

    TableName,

    TableName[Cycle]=EARLIER(TableName[Cycle])

)

VAR _running = 

SUMX(

    FILTER(

        _table,

        TableName[Driver]="Running"

    ), 

    TableName[Actual]

)

VAR _waiting = 

SUMX(

    FILTER(

        _table,

        TableName[Driver]="Waiting"

     ),

    TableName[Actual]

)

RETURN DIVIDE(_running, _waiting)

 

it worked like:

jpaguiar 
Yes you are right. Seems like the context transition effect of the SUMMARIZE function is creating a filter context issue that is not easy to understand. Replacing SUMMARIZE with GROUPBY solves the problem