May 2, 2013 at 12:04 am
Comments posted to this topic are about the item DAX Query - Part 2
May 2, 2013 at 4:52 pm
I am just starting to learn DAX. Reading my first book on the subject and this article is very timely and informative.
May 10, 2013 at 7:49 am
I was wondering, during what version of SSAS was the Tabular model introduced?
December 13, 2013 at 2:12 pm
The tabular model was introduced with SQL Server 2012 Analysis Services.
December 13, 2013 at 2:15 pm
Gary, Thank you for the interesting articles on DAX query. I am looking forward to the next installment.
October 27, 2016 at 6:30 pm
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]
October 27, 2016 at 6:34 pm
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 CalendarYear Sum`of`Sales:w00t:Product`Universe
EuropeFranceAll-Purpose Bike Stand2003 1431 1431
EuropeFranceAll-Purpose Bike Stand2004 1590 1590
EuropeFranceAWC Logo Cap 2003 881.02 881.02
EuropeFranceAWC Logo Cap 2004 1249.61 1249.61
EuropeFranceBike Wash - Dissolver 2003 151.05 151.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]
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply