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...
Hi Anonymous ,
You may create measure like DAX below.
Team Sales= CALCULATE([Individual sales], FILTER(ALLSELECTED('Kam - team'[Team]), 'Kam - team'[Team] =MAX('Kam - team'[Team])))
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.