The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
Hello dear community,
I hope you're doing well.
I have a problem with my measurement.
I have 3 tables with data (cities, highways, camera, longitude, latitude, ...)
I would like a measure that gives me the cameras for the selected city.
I have a result but it only displays one result.
Can you help me ?
thank you
Sorry I can't upload the little PBI sample.
Measure =
Solved! Go to Solution.
To list the values you can use the following measure:
Camera values =
VAR _table =
VALUES ( Localisation[Camera] )
RETURN
IF (
ISFILTERED ( Logo[City] ),
CONCATENATEX ( _table, Localisation[Camera], ", " )
)
I've attached the sample PBIX file for you
Proud to be a Super User!
Paul on Linkedin.
Hi, @Anonymous
Thanks to @PaulDBrown for a good way to do this, I didn't even notice function CONCATENATEX.
If you have solved the problem, please Accept @PaulDBrown reply as Solution to close this thread.
Other community members will easily find the solution when they get the same issue.
Best Regards,
Community Support Team _ Eason
Hi, @Anonymous
Please provide sample data (doesn't have to be real data) for all 3 tables
Proud to be a Super User!
Paul on Linkedin.
Hello,
I can't upload because I dont see how to do (dont see add fle as attachement). if you confirm that you can't help without the sample, I close my question.
Thank you
You can upload the file to DropBox, Google Drive, OneDrive... and share the link from there
Proud to be a Super User!
Paul on Linkedin.
To list the values you can use the following measure:
Camera values =
VAR _table =
VALUES ( Localisation[Camera] )
RETURN
IF (
ISFILTERED ( Logo[City] ),
CONCATENATEX ( _table, Localisation[Camera], ", " )
)
I've attached the sample PBIX file for you
Proud to be a Super User!
Paul on Linkedin.
User | Count |
---|---|
158 | |
109 | |
96 | |
83 | |
75 |
User | Count |
---|---|
154 | |
137 | |
131 | |
81 | |
62 |