Does PowerPivot have a setting similar to IgnoreUnrelatedDimensions in SSAS? My PowerPivot solution contains two measure groups with similar granularity except that one contains an additional dimension not relative to the
other. When measures from the two are combined and the additional dimension included then the data becomes fuzzy due to unrelated dimensions being displayed.
Below is an example that uses both PowerPivot and SSAS. You will notice that SSAS displays correctly but PowerPivot not.
It is true in Analysis Services(UDM), the IgnoreUnrelatedDimensions property can help you achieve this behavior. In PowerPivot, there is no such kind of property to achieve this, in order to do that in PowerPivot, you can create another measure called
IsValid that will return TRUE if the current selection in the PivotTable has a valid correspondent definition, otherwise FALSE. Finally, you can create your original measure that shows the value only when IsValid returns TRUE, otherwise return BLANK(),
you can refer to MARCO RUSSO‘s log for detail information about this topic http://www.sqlbi.com/articles/budget-and-other-data-at-different-granularities-in-powerpivot/
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.