Dynamically filter slicer on aggregate data model

[Anonymous]

I am currently setting up a aggregate data model and have run into an issue with my slicers. 

i need to find a way to dynamically filter them based on what location code a user selects. 

i found a dax statement I can use with cross filter that works but it seems to hit the direct query instead of the aggregate tables when I click on one of the slicers. 

For the example say I have two tables 

factsales and factsalesAggregate

dimensipns of

location code

sales type. 

If I don't filter the slicer will show several sales types for some locations that they don't have. 

so can someone point me in a good direction as to how to resolve this?

[amitchandak]

@Anonymous , very difficult to tell without looking at data model. Will try something on my data.

Have checked this. -https://community.powerbi.com/t5/MBAS-Gallery/Aggregation-and-composite-model-Microsoft-Power-BI-fast-and/td-p/712871

I think they explained how to work with composite model