Forum Discussion

Touaibia's avatar
Touaibia
Frequent Visitor
3 years ago

Virtuel table with a measure

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,

"CALCULATETABLE"
"LOOKUP" "DATA" "PERIOD" "INTERVAL" "BETWEEN" "SELECT" "FILTER" "TABLE"
"SELECTCOLUMNS"

1 Reply

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Hi Touaibia 

    please try

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