Measure to return multiple values from multiple tables and concatenate ? together

Hi Neiners ,
Based on your description, it looks like you want to create a DAX metric in Power BI that returns multiple values from multiple tables. This can be a bit tricky because DAX metrics typically return a single value. However, you can accomplish this by using a combination of DAX functions.
You can use variables to store values, and then you can use the CONCATENATE function to combine values from the same variables. Perhaps you could also use '&' to concatenate variables.
If you want to return multiple rows of data, you can use SUMMARIZR,SELECTEDCOLUMNS to create a new table.
You can check out these documents for more
Solved: How to get a measure to return multiple rows for e... - Microsoft Fabric Community
Solved: Measure To Return Value based on multiple criteria... - Microsoft Fabric Community
Solved: Measure to return multiple values - Microsoft Fabric Community
CONCATENATE function (DAX) - DAX | Microsoft Learn

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly