Microsoft Analysis Services, MDX, DAX, Power Pivot, Power Query and Power BI

DAX Queries, Part 6

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:

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.

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..?..

Public MDX and SSAS Training Courses

I'm running several SSAS, MDX and PowerPivot-related training courses through Technitrain in 2015. Check out the Technitrain course catalogue for full details, and to see other upcoming courses from the likes of Allan Hirt, Jamie Thomson, Andy Leonard, Thomas Kejser and others.

Need some help?

As well as being a blogger, I'm an independent consultant specialising in Analysis Services, MDX, PowerPivot and DAX. I work with customers from all round the world solving cube design problems, performance tuning Analysis Services queries and calculations, writing complex MDX and delivering training courses, and I am happy to work on short-term engagements. For more details see http://www.crossjoin.co.uk