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

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

Reply
Anonymous
Not applicable

All result with isfiltered

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

 

DimitriD_0-1636138751021.png

DimitriD_2-1636138850268.png

Sorry I can't upload the little PBI sample.

Measure = 

Camera = If(ISFILTERED(Logo[City]),FIRSTNONBLANK(City_Cam[Camera],1)," ")
If I select Paris, I see only in the card = A1 but I want to see A1, A2, ... all camera. 
 
Thank you
Thank you. 

 

1 ACCEPTED 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], ", " )
    )

result.PNG

I've attached the sample PBIX file for you 





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






View solution in original post

8 REPLIES 8
v-easonf-msft
Community Support
Community Support

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

v-easonf-msft
Community Support
Community Support

Hi, @Anonymous 

I checked your report, and you seem to use card visual to display the results. Unlike a table visual, only one final result is allowed to be displayed in a card visual. You cannot use card visual to group and display multiple results.
 
Best Regards,
Community Support Team _ Eason

 
 
PaulDBrown
Community Champion
Community Champion

Please provide sample data (doesn't have to be real data) for all 3 tables





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Anonymous
Not applicable

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





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Anonymous
Not applicable

Hello, 

 

here is the link 

Example 

 

Thank you 

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], ", " )
    )

result.PNG

I've attached the sample PBIX file for you 





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Anonymous
Not applicable

@PaulDBrown 

Thank you very much. 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.