Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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

 

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. 

 

Need Help
  • PaulDBrown's avatar
    PaulDBrown
    4 years ago

    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 

8 Replies

  • PaulDBrown's avatar
    PaulDBrown
    Icon for Community Champion rankCommunity Champion
    4 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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 

      • PaulDBrown's avatar
        PaulDBrown
        Icon for Community Champion rankCommunity Champion
        4 years ago

        You can upload the file to DropBox, Google Drive, OneDrive... and share the link from there

  • v-easonf-msft's avatar
    v-easonf-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    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

     
     
  • v-easonf-msft's avatar
    v-easonf-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    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