Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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:
Category | Value |
A | 1 |
B | 2 |
C | 3 |
I would like a measure that will determine if a user has selected the A row and return 0 for B and C:
Category | Value | Measure |
A | 1 | 1 |
B | 2 | 0 |
C | 3 | 0 |
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?
Solved! Go to Solution.
thank you for confirming
you can do this but not in the same visual.
User | Count |
---|---|
15 | |
9 | |
8 | |
6 | |
5 |
User | Count |
---|---|
31 | |
18 | |
15 | |
7 | |
5 |