Data Modeling with Multiple Filter Types Associated with one Sales Manager

[Anonymous]

Hi @Anonymous,

It sounds like you want to configure a hierarchy level security filter based on different company levels. If this is a case,  I'd like to suggest you take a look at following blogs mentioned these:

Dynamic Row Level Security (Rls) and Company Hierarchies 

Column-Level Security - 2 Methods for Restricting Column-Level Information 
Regards,

Xiaoxin Sheng

[Anonymous]

Thank you, but this is not an issue of Row Level Security. I don't need to restrict any data, just need to aggregate the information into a table correctly when a slicer is selected. 

[Anonymous]

Hi @Anonymous,

Nope, power bi does not support automatically achieve these. You still need ot consider their relationship mapping and category fields used in visual to manually control aggregated records.

Relationships in analysis services tabular models  

Use aggregations in Power BI Desktop 

Regards,

Xiaoxin Sheng