CALCULATETABLE using measure does not work as intended

[jmkvalsund]

I’m trying to create a calculated table containing salesresults for a specific team like this, using a measure to identify the team:

T_SalesByTeam = CALCULATETABLE(SUMMARIZE('Sales','Sales'[DateID],'Sales'[AccountManager],"Total sales",SUM('Sales'[Sales_Value])),FILTER('Teams',Teams[TeamID]=M_CurrentTeam))

But even though the measure M_CurrentTeam contains the right value (integer 8, put on a card for control), the table does not contain results from more than one team-member.  And I suspect not all the results for this one either.
However, if I change the statement and put in 8 as a fixed number,

T_SalesByTeam = CALCULATETABLE(SUMMARIZE('Sales','Sales'[DateID],'Sales'[AccountManager],"Total sales",SUM('Sales'[Sales_Value])),FILTER('Teams',Teams[TeamID]=8))

I get the results from all members in team 8.

There must be something I don’t understand about when or where the measure is calculated.

The measure is created like this and returns the correct value depending on [CurrentUser]

M_CurrentTeam = MAXX(FILTER(Teams,Teams[UserID]=[CurrentUser]),Teams[TeamID]))

Why can't I use this measure in the CALCULATETABLE statement?

Regards,
John 

[amitchandak · Accepted solution]

@jmkvalsund , A calculated table can not use a slicer value. means they will take static value of slicer