show column table

[alsolok]

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()
)

[Anonymous · Accepted 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.

[amitchandak]

@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())

Also refer https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slic...

[alsolok]

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