Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Consolidate % using different weighting factor

    Hi experts,   I’m struggeling with the calculation of the Utilization Rate. What in excell is very easy to calculate in PBI is becaming very challengin There are many sites with many product...
  • Cmcmahan's avatar
    Cmcmahan
    7 years ago

    The abbreviated model was VERY helpful!

     

    I got it working with this measure. The changes are highlighted in blue:

    Actual Utilization Rate = 
    VAR ReferenceTime = 240*8*2/12 
    RETURN
    DIVIDE( 
        SUMX( VALUES(PartesProduccionLineas[Linea]), [Opening Time H] * [Speed units hour] * [Opening Time H]/320) ,
        SUMX( VALUES(PartesProduccionLineas[Linea]), [Opening Time H] * [Speed units hour] )
    )

    The issue was that it was aggregating by each entry in the table, instead of by the entire line.  Now that it's grouping properly, we get the expected result.