Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I'm using a column as a Power BI binary filter. The data frame is like:
So I'm using the column "Value" as a binary filter on my dashboard. I expect that when I select $ on visual my calculated column bring this:
Where 1 means that $ was selected by user.
Any ideas on how to generate dax capable of classifying whether the value was selected or not in the visual?
@Anonymous
The values you in the table will not be affected by any selection being made from the filters. Hope your $ and % value column is on a slicer for the user to select, You need to get the value selected using SELECTEDVALUE('TABLE'[VALUE]) and incorporate it in the measures that need to be evaluated based on the selection.
Hope this made it clear.
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
42 | |
32 | |
30 | |
18 | |
18 |