Virtuel table with a measure

[Touaibia]

Hi everyone ,

I want to creat a table based on two tables : 

Sales / Custumers ( i have for each custumer the name of the sales rep responsable for the account) 

I just want to creat a table that gives me the number of custmers that had purchase minimum 100$ by sales rep

I'm struggeling with calculatetable selectcolumns but it's an epic fail ^^

Thanks by advance 

BR,

[tamerj1]

Hi @Touaibia 

please try

Table1 =
ADDCOLUMNS (
VALUES ( Customer[SalesRepID] ),
"Number of Customers",
COUNTROWS (
FILTER (
CALCULATETABLE ( VALUES ( Customer[CustomerID] ) ),
[Sales Amount] > 100
)
)
)