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.
I have a table below with two columns, President and Vice President. I would like to create a measure that will be placed on a card. The measure would default to blank when no item on the below table is selected
When the president column of my table is selected it will return the corresponding president as shown below.
When Vice president is in a table by itself and is selected it will return the corresponding president as shown below
Solved! Go to Solution.
You can create a measure to get the column you've selected. The second argument is the alternate result. This is what will display if the selected value is <>1 record.
President = SELECTEDVALUE('Table'[President], '')
You can create a measure to get the column you've selected. The second argument is the alternate result. This is what will display if the selected value is <>1 record.
President = SELECTEDVALUE('Table'[President], '')
@Syk Thanks for your response. it does not seem to work in the last scenario where im selecting from a table with on the Vice President
You want the President to return when you select the VP, correct? I believe your screenshot shows it doing that and in my test it works. I did make a slight adjustment to the measure I gave you just changing the single quotes to double quotes.
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 |
---|---|
102 | |
101 | |
78 | |
70 | |
64 |
User | Count |
---|---|
140 | |
106 | |
100 | |
83 | |
73 |