Forum Discussion
Dynamically filter slicer on aggregate data model
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?
1 Reply
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
