Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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,
Hi @Touaibia
please try
Table1 =
ADDCOLUMNS (
VALUES ( Customer[SalesRepID] ),
"Number of Customers",
COUNTROWS (
FILTER (
CALCULATETABLE ( VALUES ( Customer[CustomerID] ) ),
[Sales Amount] > 100
)
)
)
User | Count |
---|---|
47 | |
28 | |
23 | |
18 | |
15 |
User | Count |
---|---|
55 | |
34 | |
18 | |
17 | |
15 |