Forum Discussion

Anonymous

Not applicable

6 years ago

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

Super User

6 years ago

Selecting in a variable and using is later should give

Team Sales = 
 var _team= allselected('Kam - team'[Team])
 return
 CALCULATE([Individual sales],all('Kam - team'[Kam]),'Kam - team'[Team] =_team)
or
CALCULATE([Individual sales],all('Kam - team'[Kam]),'Kam - team'[Team] in _team)

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

Related content