topic Re: Measure not working in DAX Commands and Tips

Measure not working

agius — Thu, 04 Jun 2020 12:09:48 GMT

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 🙂

stevedep — Thu, 04 Jun 2020 12:30:24 GMT

Anonymous — Thu, 04 Jun 2020 14:34:57 GMT

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 — Tue, 09 Jun 2020 07:55:20 GMT

Phar Thanks so much! This worked like a charm!