Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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".
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |