filter by no of sales

[Anonymous]

Hi,

I try to create a calculated measure for total No of Sales for the month for the employee to the Sales table 1 below. With that, I wish I will be able to filter the table Say only show employee sales who has more than 4 sales in a month (see table 2)

Is this achievable?

Thanks,

employee number	sales date	No of Sales	sales date key	total no of sales for the month for the employee
100806	01-May-16	1	20160501	4
100801	03-May-16	2	20160503	6
100806	08-May-16	3	20160508	4
100801	06-May-16	4	20160506	6
100806	01-Apr-16	2	20160401	7
100801	02-Apr-16	1	20160402	1
100806	03-Apr-16	4	20160403	7
100806	01-May-15	1	20150501	7
100807	02-May-15	4	20150502	4

employee number	Sales date	sales amount	sales date key	total sales for the month for the employee
100801	03-May-16	2	20160503	6
100801	06-May-16	4	20160506	6
100806	01-Apr-16	2	20160401	7
100806	03-Apr-16	4	20160403	7
100806	01-May-15	1	20150501	7

[achinm45 · Accepted solution]

Yes this is achievable.

Trying use the formula as put in screenshot here.

[Anonymous]

@achinm45 You are the Dax champion. Thanks.

[achinm45]

Thanks @Anonymous  for motivation !

[SabineOussi]

Did you try putting your measure as a visual level filter and choose it to be greater than 4?