Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

segment filter: choice


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']),


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".

Community Support
Community Support

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.



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

Helpful resources

PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!


Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors