Forum Discussion

KevBI's avatar
KevBI
Helper I
4 years ago
Solved

Need help with Measure please

Hello Guys,   I have following Table  The Column I am having problems with is the marked AOPWD Column. It is a calculated column :  AOPWD = 'Spoilage AOP 2022'[AOP] / 'Spoilage AOP 2022'[...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi KevBI ,

     

    I think there is something wrong in your calculate logic.

    The calculate logic of your measure is 60900 / (20 * 7) = 435.

    Try this code.

    AOPWDMeasure =
DIVIDE (
    SUM ( 'Spoilage AOP 2022'[AOP] ),
    SUM ( 'Spoilage AOP 2022'[WDMonth] )
) * ( [workdays] )

    Result is as below.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

KevBI's avatar
KevBI
Helper I
4 years ago

amitchandak 
So when looking at the first row, Value Stream CE-E, filtered on 01.02-09.02,

we have an AOP of 60900, WDMonth = 20 and workdays = 7.

So it should calculate 60900 / 20 * 7 = 21315
The Measure puts out 435 though.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi KevBI ,

     

    I think there is something wrong in your calculate logic.

    The calculate logic of your measure is 60900 / (20 * 7) = 435.

    Try this code.

    AOPWDMeasure =
DIVIDE (
    SUM ( 'Spoilage AOP 2022'[AOP] ),
    SUM ( 'Spoilage AOP 2022'[WDMonth] )
) * ( [workdays] )

    Result is as below.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.