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 everyone,
I want show table column, I use the fonction selectedvalue('tab'[name]).
This fonction is correct?
is there possibity to use switch and selectedvalue ??
Example:
Types =
IF(HASONEFILTER('Choice'[type]),
SWITCH(SELECTEDVALUE('Choice'[type]),
"bob", SELECTEDVALUE('tab'[cp]) & SELECTEDVALUE('tab2'[cp2]) & SELECTEDVALUE('tab3'[cp3]),
"alice", SELECTEDVALUE('tab4'[axe],
"tim", SELECTEDVALUE('tab5'[pos]),
BLANK()
)
Solved! Go to Solution.
Hi @alsolok ,
You can't filter columns with only one measure. You need to create multiple measures. Please check the attachment.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @alsolok ,
You can't filter columns with only one measure. You need to create multiple measures. Please check the attachment.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@alsolok , this should work
Types =
IF(HASONEFILTER('Choice'[type]),
SWITCH(SELECTEDVALUE('Choice'[type]),
"bob", SELECTEDVALUE('tab'[cp]) & SELECTEDVALUE('tab2'[cp2]) & SELECTEDVALUE('tab3'[cp3]),
"alice", SELECTEDVALUE('tab4'[axe]),
"tim", SELECTEDVALUE('tab5'[pos]),
BLANK()
), blank())
it doesn't work.
I want to make sure that if you select "bob" that it shows me on the map the values of cp1, cp2 and cp3.
the same goes for the others.
This measurement that I am creating I will place it in the location, latitude and longitude fields on an arcgis map
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |