measure values in hierarchies do not roll up effectively when row security is applied to a tabular model - by Cathy Dumas - Simba

Status : 

 


15
0
Sign in
to vote
ID 733766 Comments
Status Active Workarounds
Type Bug Repros 2
Opened 3/27/2012 6:44:33 PM
Access Restriction Public

Description

The way hierarchies are displayed doesn't change when row security is applied to a model.

Because visual totals always apply, it is impossible to correctly compute aggregate totals (or reliably blank them out) when you drop a hierarchy into a pivot table if bits of the hierarchy have been secured.

Either there should be a way to manually handle the problem in DAX, or better smarts built into hierarchies that allow them to adapt to row security.
Sign in to post a comment.
Posted by Microsoft on 4/3/2012 at 10:28 AM
Thanks Cathy. I agree that we need to do something here.
We're filing this for consideration in the next release.

Thanks,
-Howie
Posted by Cathy Dumas - Simba on 3/30/2012 at 2:05 AM
OK I was wrong. There is a way to manually work around in DAX. In a six level hierarchy, it requires the use of 6 calc columns and 6 intermediate measures before actually doing the final count in a nested if statement 7 levels deep (see attached). I think though that there should be a simpler way to achieve this result.