dynamic DAX formula based on two slicer for budget

[Anonymous]

Hi everyone, 

I want to show the budget (plan values) based on two slicers (Sales District and Product Group). 

No I am just wondering how I can create a dynamic DAX formula based on these two different slicers. 

I hava a table for the budget with the information of the Sales District and Product Group. 

Any suggestions how I can connect it? 

Many thanks in advance! 

[amitchandak · Accepted solution]

@Anonymous , Ideally you should have common tables(Sales District and Product Group) joined with Budget. That will filter data automatically 

if they are not you can try measure like 

Calculate(sum(Budget[Value]), filter(Budget, Budget[Sales District]  in values('Sales District'[Sales District])  && Budget[Product Group]  in values('Product Group'[Product Group])))