Need help to write a WAVG calc using DAX

[PPerera]

Hi 

Please help me to write this WAVG Price formula using DAX

Sum( Price * ABS(MV) ) / Sum( CASE(Price = 0 , 0 ,ABS(MV) )

Assume Price and MV come from table "Sales"

Thanks

[Irwan · Accepted solution]

hello @PPerera 

maybe something like this (not sure if this works since i dont test this DAX).

DIVIDE(
   SUMX(

      'Sales',

      'Sales'[Price]*ABS('Sales'[MV])
   ),

   SUMX(

      FILTER(

         'Sales',

         'Sales'[Price]>0
      ),

      ABS('Sales'[MV])
   )
)

Hope this will help.

Thank you.

[PPerera]

Thank you very much Irwan. It worked. This forum is full of great experts. This was my second question and got the answer almost immediately. Thanks again.

[Irwan]

hello @PPerera 

glad to be a help.

Thank you.