The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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 | |
13 | |
8 | |
6 | |
6 |
User | Count |
---|---|
24 | |
19 | |
12 | |
9 | |
7 |