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...
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.