측정값 설정에서..
COUNTROWS( DISTINCT( '테이블명'[컬럼명] ) )
하면.. distinct count 된다. 최근 버전은 distinct count가 기본으로 있다. ![[http]](/moniwiki/imgs/http.png)
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))
- Dynamic DAX Query Tables in Excel 2013
- A Different Approach To Last-Ever Non-Empty in DAX
- DAX Query Basics
- PowerPivot Top N Reports Using Excel Cube Formulas
- OR Selections in DAX
- Comparing Any Two Time Periods in DAX
- Solving the Events-In-Progress Problem in DAX V2.0
- DAX Queries, Part 1
- DAX Queries, Part 2
- DAX Queries, Part 3
- DAX Queries, Part 4
- DAX Queries, Part 5
- DAX Queries, Part 6
- Microsoft® SQL Server® 2012 PowerPivot® for Microsoft® Excel® 2010 - RTM
- Distinct Count Measure in PowerPivot using DAX
- Microsoft SQL Server 2008 R2 - PowerPivot for Microsoft Excel 2010 - RTM