Forum Discussion
DAX filter
Hi, I need to calculate the Sales of a team ignoring the Single salesperson selection but considering the team the person belongs to: In this case, I need the team sales to be the sum of ON...
Team Sales = CALCULATE(
sum([Individual sales]),
all('Kam-team'[salesperson]),
allselected('Kam - team'[Kam]))
Maybe something like this?
Not sure if { all('Kam-team'[salesperson]),} is needed
Hi wvdv,
Thanks for your answer.
Actually I have this dimension table:
I need that if the filter is Tiphaine Boehm team sales sum all of the sales when team = FR, if the filter is Tania Gracia then sum all of the sales with team = ES etc
- Okay this works in my test:Where table 1 has two columns: kam and team.Table 2 has two columns: kam and sales.I only recreated part of your table.Relationship is one to many from table 1 to table 2.Measure = CALCULATE(SUM(Table2[Sales]),ALL(Table1[Kam]),ALLSELECTED(Table1[Team]))
Btw: be aware that in my example, you would have to filter kam on table 1, not on table 2.