Measure not working

[agius]

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 🙂

[harshnathani · Accepted solution]

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

[agius]

@Phar Thanks so much! This worked like a charm!

[stevedep]

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490