Filter my data by a measure

[mrouxfrench]

Hi,
I would like to create a slicer which filters my data following a measure value.

Basically my data is a fact table storing customers purchases monthly:

Customer ID	Month	Nb purchases
A	October	13
B	October	8
A	November	14
C	November	20
B	December	31

I created a measure that calculates for my customers if they appear in all selected months or not (returns "Yes" or "No" for each customer)

Now I want a to set a slicer with Yes/No options.

For example in the above example: let's say I selected months October and November in a slicer, I would like a new Yes/No slicer that updates my table on customer A rows (because he appears in oct and nov)

Customer ID	Month	Nb purchases
A	October	13
A	November	14

Can someone help me on this?

Sorry if it's obvious to you, I claim myself to be a PBI newbie 🙂

[amitchandak]

@mrouxfrench , Not very clear , Try a measure like

measure =
var _max = maxx(allselected(Table), Table[Month])
return
if(calculate(distinctcount(Table[Month]), allexcept(Table, Table[Customer ID])) >=_max, "Yes", "No")