Forum Discussion
show column table
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()
)
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.
3 Replies
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
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.
