Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I'm trying to get a title to show what I have selected in one filter, no matter the number of items I select. For example, imagine that I have a column called "Countries" with a list of all countries in Europe and I want a title to show if I select France, "Sales of France", but if I select France and Germany, I would like to see "Sales of France and Germany" or if I select France, Germany and Spain I would like to see "Sales of France and Germany and Spain" and so on. Is that possible?
Thanks!!
Solved! Go to Solution.
measure = "Sales for " & concatenatex(allselected(County[Country]) , [Country], " and ")
or
measure = "Sales for " & concatenatex(allselected(County[Country]) , [Country], " , ")
measure = "Sales for " & concatenatex(allselected(County[Country]) , [Country], " and ")
or
measure = "Sales for " & concatenatex(allselected(County[Country]) , [Country], " , ")