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!
Go to Solution.
@Sunshine555 , 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])))
View solution in original post
Learn how to create your own user groups today!
Click here to read more about the October 2021 Release!
Check out the new Power Platform Community Connections gallery!
Mark your calendars and join us for our next Power BI Dev Camp!