Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
alsolok
Helper I
Helper I

segment filter: choice

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

2 REPLIES 2
v-cazheng-msft
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

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.