Passing measure to the slicer

[bml123]

Hi,

I have a measure called measure 1 which calculates the difference between this year's sales and the previous sales.

I have created another measure to show if the above measure value is positive or negative for each product id. 

I want to pass this measure in the slicer so that when the user selects 'Positive' it will show the positive values of measure 1 and shows negative values if the user selects 'Negative'.

But I am unable to pass measure in the slicer.  Is there a way to acheive this?

[naveenmechu]

Hi,

Create a lookup table having "Positive" and "Negative" value. Tweak measure by using selectedvalue. 

Hope It will help you, Please share Pbix sample file if need detailed help.

Thanks 

Naveen Mechu

[bcdobbs]

You'd need to turn the logic on it's head. 

You want to use a disconnected table which just has "Postive" and "Negative" in it.

Then use SELECTEDVALUE to get the value from the slicer and wire it into a measure which can be used on the visual level filter. 

Sorry that's a very hand wavy description. If you share a demo file I can try and help put it into action.