Chris Webb's BI Blog

Analysis Services, MDX, PowerPivot, DAX and anything BI-related

DAX Queries, Part 6

with 5 comments

Before I start this post, I’d like to mention that Cathy Dumas of the dev team has started blogging on BISM topics here: http://blogs.msdn.com/b/cathyk/. There are some good posts up already, with more to come I’m sure.

Anyway, back to DAX queries. Just a quick post today about the ROW() function, which returns a table containing a single row of data. Here’s an example of its use inside a query:

evaluate(
row(
"Column 1"
, "Some text"
, "Column 2"
, countrows(dimdate)
)
)

image

It’s pretty simple: the parameters represent a series of column name/DAX expression pairs for your table, so in this example I’m defining a table with two columns and one row, with the first column returning the text “Some text” and the second column returning the result of the expression countrows(dimdate). I understand it is intended for use by client tools such as Crescent when they want to return a series of grand totals without any detail data.

Written by Chris Webb

August 10, 2011 at 4:37 pm

Posted in DAX

5 Responses

Subscribe to comments with RSS.

  1. [...] DAX Queries, Part 6 « Chris Webb’s BI Blog [...]

  2. This is very useful for sharepoint bi beginners. Thanks for your useful information. please do more post.

    ilinkuser

    August 11, 2011 at 10:02 am

  3. Hi chris ,

    I know that this is not right thread to post this ..But i want you to please clarify one issue ..
    i have a cube bulid using SSAS . But in each dimension of it i am getting a attribute called “unknown” .I dont have null values in those dimensions for SSAS to convert them to “unknown” ..
    When i had seen the dimension properties of that dimension there is a property called UNKNOWN MEMEBER.
    that property was set to true .If we change that to none UNKNOWN MEMBER issue would be solved , But what is confusing me really is , How that UNKNOWN members is getting generated when the dimension is not having null values for any of the attributes..?..

    Hope i am clear in explanation ..

    Rajesh

    August 16, 2011 at 10:39 am

    • Hi Rajesh,

      The Unknown Member is created automatically, whether there are any missing key values or not. As you said you can hide it, so there’s no need to worry about it.

      Chris

      Chris Webb

      August 18, 2011 at 8:14 pm

  4. [...] part 6, I’ll look at the Row() [...]


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

Follow

Get every new post delivered to your Inbox.

Join 3,202 other followers

%d bloggers like this: