DAX Query - Part 2

Question

Post reply

DAX Query - Part 2

gary.strange-sqlconsumer

SSCommitted

Points: 1816
More actions
May 2, 2013 at 12:04 am

#293413

Comments posted to this topic are about the item DAX Query - Part 2

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Misha_SQL SSCertifiable Points: 5407 More actions · Answer 1

I am just starting to learn DAX. Reading my first book on the subject and this article is very timely and informative.

hdsturgill Grasshopper Points: 21 More actions · Answer 2

I was wondering, during what version of SSAS was the Tabular model introduced?

tallan Valued Member Points: 65 More actions · Answer 3

The tabular model was introduced with SQL Server 2012 Analysis Services.

tallan Valued Member Points: 65 More actions · Answer 4

Gary, Thank you for the interesting articles on DAX query. I am looking forward to the next installment.

tyjulianchen Valued Member Points: 65 More actions · Answer 5

Hi Gary,

I applied the calculate () and ALL () function as follows but got the wrong Product Universe numbers. Could you please help me dig out what's the problem? By the way, after conducting format() function, the value turns out to be text instead of number in Pivot table, why?

GroupCountryProductName CalendarYearSum`of`SalesProduct`Universe

EuropeFranceAll-Purpose Bike Stand2003 14311431

EuropeFranceAll-Purpose Bike Stand2004 15901590

EuropeFranceAWC Logo Cap 2003 881.02881.02

EuropeFranceAWC Logo Cap 2004 1249.611249.61

EuropeFranceBike Wash - Dissolver 2003 151.05151.05

Thanks.

define

measure 'Sales'[Sum of Sales] = SUM('Sales'[SalesAmount] )

measure 'Sales'[Product Universe] = calculate( 'Sales'[Sum of Sales], ALL( Products[ProductName] ) )

evaluate(

summarize(

'Sales',

'Territory'[Group],

'Territory'[Country],

'Products'[ProductName],

'Calendar'[CalendarYear],

"Sum of Sales", [Sum of Sales],

"Product Universe",[Product Universe]

)

order by

'Territory'[Group]

,'Territory'[Country]

,'Products'[ProductName]

,'Calendar'[CalendarYear]

tyjulianchen Valued Member Points: 65 More actions · Answer 6