DAX: NAAN is good…NAN is not…use DIVIDE

Just a minute while I reinvent myself …

Measure [ExampleWithoutDivide] divides one measure by another in your Tabular cube…and when you run a query in Management studio you get -1.#IND values …

Screen Shot 2014-06-18 at 1.31.29 pm

And in your Reporting Services dataset you get NaN values …

Screen Shot 2014-06-18 at 1.32.51 pm

Use DIVIDE in your MDX calculation as illustrated in the [ExampleWithDivide] measure above…

ExampleWithDivide:=DIVIDE([Measure1],[Measure2])

Oe Use an alternative result option to return a constant numeric value instead …

Screen Shot 2014-06-18 at 1.50.04 pm

ExampleWithDivide:=DIVIDE([Measure1],[Measure2],1)

See you in places
You’ll be upstairs…
And I’ll be there too…

About AussieBICG

Connect with me here https://au.linkedin.com/in/aussiebicg

1 Response

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s