Measure filtering amount above value

[fabiocovre]

Hi,

I have the following table as example. I'd like to create a measure to show only the product who sold more than 5 in the filtered period.

Product	Month	No. Events
A	jan/18	1
A	jan/18	2
A	jan/18	0
A	feb/18	4
A	feb/18	2
A	feb/18	1
A	feb/18	1
A	mar/18	2
A	mar/18	1
B	jan/18	3
B	jan/18	2
B	jan/18	1
B	feb/18	0
B	feb/18	2
B	feb/18	1
B	feb/18	2
B	feb/18	0
B	mar/18	6

If I filter all the months, I'd like to see:

Product             Sum Events

A	14
B	17

If I filter only January, I'd like to see:

     Product         Sum Events

B

6

If I filter only February, I'd like to see:

Product             Sum Events

A	8
B	5

If I filter March, I'd like to see:

Product             Sum Events

B

6

Thank you in advance!

Fabio

[v-piga-msft]

Hi @fabiocovre,

The solution of Ashish_Mathur should meet your requirement.

If you have solved the problem, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please describe your logic in more details.

Best  Regards,

Cherry

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[smpa01]

@fabiocovreyou can set up a table and chiclet slicers for filtering as following

Master

When you do the filtering on chiclet slicers, it would exactly do the filtering as you imagined

Filtering

The file is here -  https://drive.google.com/open?id=1NjY48LC3tNx3O7oZj818OMWgCN6CMrkVT