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.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
4 years ago

Hi,

Modify your measure to

AOPWDMeasure = Divide(sum('Spoilage AOP 2022'[AOP]) ,sum( 'Spoilage AOP 2022'[WDMonth])) * ([workdays])

Hope this helps.