#title Power Pivot

측정값 설정에서..

 {{{COUNTROWS( DISTINCT( '테이블명'[컬럼명] ) )}}}

하면.. distinct count 된다. 최근 버전은 distinct count가 기본으로 있다. 

 * [http://powerpivotfaq.com/Lists/TGPPF/DispForm.aspx?ID=95 How do I group numbers in a PowerPivot PivotTable like I can in an Excel PivotTable?]
  {{{
1) If you want to start at zero i.e. 0-9, 10-19 etc, enter a formula like:
 
=FLOOR('Number Groups'[Num],10)&" - "&CEILING('Number Groups'[Num],10)+IF(MOD('Number Groups'[Num],10)>0,-1,10-1)
 
2) If you want to start at one i.e. 1-10, 11-20 etc, enter a formula like:
 
=FLOOR('Number Groups'[Num],10)+IF(MOD('Number Groups'[Num],10)>0,1,-(10-1))&" - "&CEILING('Number Groups'[Num],10)
 
3) 2) If you want to start at ten i.e. <10, 10-19 etc, enter a formula like:
 
=IF('Number Groups'[Num]<10,"<"&10,FLOOR('Number Groups'[Num],10)&" - "&CEILING('Number Groups'[Num],10)+IF(MOD('Number Groups'[Num],10)>0,-1,10-1))
 }}}

 * [http://feedproxy.google.com/~r/wordpress/Cpjz/~3/qNayJa5iQ4E/ Dynamic DAX Query Tables in Excel 2013]
 * [http://cwebbbi.wordpress.com/2013/01/15/a-different-approach-to-last-ever-non-empty-in-dax/?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+wordpress%2FCpjz+%28Chris+Webb%27s+BI+Blog%29&utm_content=Google+Reader A Different Approach To Last-Ever Non-Empty in DAX]
 * [http://www.sqlservercentral.com/articles/DAX/92740/ DAX Query Basics]
 * [http://feedproxy.google.com/~r/wordpress/Cpjz/~3/GCctKKbiieA/ PowerPivot Top N Reports Using Excel Cube Formulas]
 * [http://feedproxy.google.com/~r/wordpress/Cpjz/~3/Msqti02noTQ/ OR Selections in DAX]
 * [http://feedproxy.google.com/~r/wordpress/Cpjz/~3/wrk1chzJO6Y/ Comparing Any Two Time Periods in DAX]
 * [http://feedproxy.google.com/~r/wordpress/Cpjz/~3/mfeQGwGcJRg/ Solving the Events-In-Progress Problem in DAX V2.0]
 * [http://feedproxy.google.com/~r/wordpress/Cpjz/~3/gPrqQ4TjikM/ DAX Queries, Part 1]
 * [http://feedproxy.google.com/~r/wordpress/Cpjz/~3/OdITPznW1sk/ DAX Queries, Part 2]
 * [http://feedproxy.google.com/~r/wordpress/Cpjz/~3/owgpCFcHZrE/ DAX Queries, Part 3]
 * [http://feedproxy.google.com/~r/wordpress/Cpjz/~3/7tVWgnQtqHc/ DAX Queries, Part 4]
 * [http://feedproxy.google.com/~r/wordpress/Cpjz/~3/0ZDKiRg0ReY/ DAX Queries, Part 5]
 * [http://feedproxy.google.com/~r/wordpress/Cpjz/~3/E3JK02Ai4KY/ DAX Queries, Part 6]
 * [http://www.microsoft.com/downloads/ko-kr/details.aspx?familyid=4b5d8276-d8c8-49b3-a653-f09f744ed9c5 Microsoft® SQL Server® 2012 PowerPivot® for Microsoft® Excel® 2010 - RTM]
 * [http://sqlblog.com/blogs/marco_russo/archive/2009/12/26/distinct-count-measure-in-powerpivot-using-dax.aspx Distinct Count Measure in PowerPivot using DAX]
 * [http://www.microsoft.com/downloads/ko-kr/details.aspx?FamilyId=e081c894-e4ab-42df-8c87-4b99c1f3c49b&displaylang=ko Microsoft SQL Server 2008 R2 - PowerPivot for Microsoft Excel 2010 - RTM]