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.

amitchandak's avatar
amitchandak
Super User
4 years ago

KevBI , Try like, if workday is measure

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

 

or

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

 

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

    • amitchandak's avatar
      amitchandak
      Super User
      4 years ago

      KevBI , what is the expected number. as number seem fine to me

       

      there should small diff in the calculation

      AOPWDMeasure = Divide(sum('Spoilage AOP 2022'[AOP]) ,sumX('Spoilage AOP 2022', 'Spoilage AOP 2022'[WDMonth] * [workdays]))
    • 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.