Forum Discussion
calculate client count
Hi Community..!! I wanted to calculate count of clients that ordered more than 25000 products. Could anyone help me to solve this.? We have a client_id and quantity of products.
Anonymous , create a measure like
countx(filter(sumamrize(Table, Table[Client], "_1", sum(Table[Amount])), [_1] >25000), [Client])
Hi amitchandak
Client_id is in Client table and Quantity in Order table
what should be the relationship between these two tables?