Creating Measure Based on Parameter Then Adding Measure In Slicer

[alee5210]

Hi All,

Just running into a bit of an issue. I have a report that has 2 columns, the Name and the Points.

I've also created a numeric parameter where users can select a cut off value for points.

After creating this parameter, I've created the measure 'Above Cutoff' where if the points are below the cutoff, then it will return N, otherwise Y. 

An example is below where the parameter has been set to 7. 

The issue I'm having is that I want to create a slicer based on the 'Above Cutoff' measure. So if a person is above the cutoff, they can be filtered and I would only be left with the 'Y' values in the Above Cutoff column.

Is this possible?

Name		Points		Above Cutoff
Glen		2		N
Sarah		2		N
Blair		5		N
Francis		7		Y
Jeffrey		2		N
Claire		8		Y
Lance		10		Y
Kirsten		9		Y
Hillary		4		N
Eric		10		Y

[parry2k]

@alee5210 I wish you had clarified that upfront and saved both of us a lot of times. I guess you already have a solution. Good luck!

[alee5210 · Accepted solution]

I have worked it out using this method described here, which involves creating a new table

https://www.youtube.com/watch?v=AHiCE1N0XHE

[parry2k]

If you use my measure it will only show yes

[alee5210]

I would like users to have the option to select "Yes", "No" or both from a slicer. It's not just that I want only "Yes" to be shown in that column. Apologies if it was not clear earlier

[parry2k]

@alee5210 Keep in mind, I assume Points is a column.

[parry2k]

@alee5210 try this measure and use it in the visual.

Above Cut Off = 
IF ( SELECTEDVALUE ( Table[Points] ) >= [Parameter Value Measure], "Yes" )

[alee5210]

@parry2k 

Thanks for your response. I've already created the measure so that isn't the issue. My issue is trying to then put that into a slicer because it seems like it does not work. I want to get only the 'Y' in the table and to filter out all the 'N'. Do you know if this is possible?