Forum Discussion
agius
6 years agoRegular Visitor
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 🙂
- Anonymous6 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 timeRegards,Harsh Nathani
Anonymous
6 years agoNot applicable
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