| Hierarchies, Oh Hierarchies…where are thou? (in PowerPivot) |
| Written by Denny Lee |
| Thursday, 13 May 2010 03:00 |
|
I had a great question from a customer concerning something weird happening with PowerPivot relationships. In this example, we have two tables such as city and state. With the City-State mapping table, it is apparent that the cities of Boston, Quincy, Norwood belong to MA while Seattle and Redmond belong to WA. Even though the relationship makes sense (as per below) the output doesn’t! Read more... |
Author articles
- Help, my PowerPivot for SharePoint Lists Atom Feed has fallen and it can’t get up!
- PowerPivot Technical Diagram: PowerPivot Security Architecture
- PowerPivot, you are so insensitive! (case that is)
- "DAX Reference" - free online chapter from the book "Professional Microsoft PowerPivot for Excel and SharePoint"
- Hierarchies, Oh Hierarchies…where are thou? (in PowerPivot)
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
