Forum Discussion

agius's avatar
agius
Regular Visitor
6 years ago
Solved

Measure not working

Hi,

 

Can someone help me understand why this Measure is not working?

 

(DIVIDE(
SUM('Adform - Devices'[NDC]),
SUM('Adform - Devices'[Impressions]))
) * 1000
 
Thanks for the help 🙂
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi agius ,

     

    Try simplifying it and see if you are getting the correct values.

     

    Measure =

     

    Var a = SUM('Adform - Devices'[NDC])

    var b = SUM('Adform - Devices'[Impressions])

     

    RETURN

     

    //a

    //b

     

    DIVIDE(a,b) * 1000

     
     
    See if your values of a and b are correct by uncommenting them one at a time
     
    Regards,
    Harsh Nathani

3 Replies