Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Post Patron
Post Patron

Passing measure to the slicer



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?


Helper I
Helper I


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.



Naveen Mechu

Super User
Super User

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.

Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

Helpful resources

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.


Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.


Fabric certifications survey

Certification feedback opportunity for the community.