segment filter: choice

[alsolok]

Hello,

How to combine one or more columns of a table / several tables based on a segment of filter. for example :

Card Types =
IF (HASONEFILTER ('Choice of Cards'),
SWITCH (SELECTEDVALUE ('Choice of Cards'),
"Stop", table ['col'] & table2 ['columns'] & table3 ['test'],
"Rounding", tab ['CP'] & tab2 ['PC "],
"IRIS", tabl ['name'] & tabl2 ['exple']),
BLANK ()
)

in the filter if I make a choice of display by "Stop" it displays me according to the "Stop" which is on a table, the same thing if I make a choice by "Rounding" it also displays me by values for "Rounding".

[v-cazheng-msft]

Hi @alsolok 

Can you provide some sample data without sensitive data to explain the structure of your table and which table is the ‘Choice of Cards’ coming from?

Best Regards

Caiyun Zheng

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[alsolok]

Table Choice cartes has one column and three rows : (stop, arrondi, iris)

Table 1 has four column ( id, name, func, cp)

Table 2 has four column (idt, lat, log, func) 

Table 2 and Table 1 has the relationship (func, func)

Table 3 has three column (id, pos, name)

My problem is :

I went show in function the select ( stop, arrondi ans iris) in the map.

the measure I want to create is to put it in the properties of a map (location, longitude, latitude):
For example in location I place the measure, longitute also and the same thing for latitude