This topic contains 4 replies, has 3 voices, and was last updated by 
-
Posts
-
Quick “Is there a way” Question:
Is there a way to see the results of a Summarize function statement?
For example:
SUMMARIZE(vDimPractice,vDimPractice[MbrNameID],”12-month Sales”,vFactTransaction[DLR_PRDCTN_NET_SumOf_MoRolling12])
The SUMMARIZE() function is part of a larger expression to calculate percentiles, based upon Colin Banfield’s posts back in 2011.
I have SSMS.
Thank you!
Ron,
There are at least two ways that I know of to see the results of a SUMMARIZE function statement:
1) Use DAX Studio
https://daxstudio.codeplex.com/
2) Create a link-back table
http://www.sqlbi.com/articles/linkback-tables-in-powerpivot-for-excel-2013/
Tom,
You reminded me of DAX Studio. Thanks!!
Ron
Hi Tom
Summarize can be used in a measure without using a link back table?
If i use a linkback table can i pre filter my table results if the table stretches across 1mil plus lines?
Normally it forces you to choose a table when creating a linkback table but the table i want has more than 1 mil lines, this then does not load into a table format
You can use SUMMARIZE in a measure without using a link back table. To keep your data from exceeding one million lines, the pre-filter would need to be in the DAX query for the link back.
Power Query in many cases is the preferred solution over link back tables because of the 1 million row limitation.
The topic ‘See SUMMARIZE() Results’ is closed to new replies.