| Revisiting ALL() |
| Written by Rob Collie |
| Thursday, 25 February 2010 22:51 |
|
Yes, I’ve used ALL() a number of times already. But I’ve never covered it directly – it’s always been a side topic to something else. So I thought it was time I went back and made sure I had a specific post on it. The short version is: ALL() removes filters from specific fields during a measure calculation. It “De Niros” your measure… but in a controlled manner.
|
Most Popular
- Step by step guide on installing PowerPivot for SharePoint on a single machine
- List of suggested datasets to test PowerPivot
- List of PowerPivot DAX functions with description
- How to install PowerPivot for Excel and list of know issues
- Microsoft Virtual Lab: PowerPivot for Excel 2010 Introduction
- List of PowerPivot DAX functions (short)
- PowerPivot's impact on BI pros?
- Recorded webcast - A Preview to PowerPivot Server Best Practices
