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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
planks
New Member

Can a measure determine filtering outside the row context?

I am trying to create a measure that will determine if the user has clicked on another row in a table and return 0 if it has.  For example, using this dataset:

CategoryValue
A1
B2
C3

 

I would like a measure that will determine if a user has selected the A row and return 0 for B and C:

CategoryValueMeasure
A11
B20
C30


I thought this would be straightforward but I've tried using ISFILTERED, HASONEVALUE, HASONEFILTER, and the row context thwarts me each time.  Is what I'm trying to do possible?

 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

you can do this but not in the same visual.

View solution in original post

2 REPLIES 2
planks
New Member

thank you for confirming

lbendlin
Super User
Super User

you can do this but not in the same visual.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.