Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

How to use return for multiple values

Good morning everyone: I have 2 variables already calculated and I need to display them in 2 rows in the same table. How can I do it? I used RETURN but it only lets me show a singl...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Good morning, it hasn't worked for me yet.

 

I will explain a little better. What happens is that I have a measure, which results in some names that can vary. The problem is that I need those names to be able to filter another table where I have those names that help me draw a map. In the map table I have latitude, longitude and names. But I have not been able to do it, I have not been able to relate the result of the names of the measures with the names of the map table.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous 

    Did your name measure based on another table or this map table?

    You can try to filter the name of the map table by a slicer. However, we can't build a slicer by a measure, you may need to build a name table by dax and relate this table with map table by name.

    Ex:

    My sample measure may be like:

     

    Measure.Name = CALCULATE(MAX('Table'[Name]),FILTER('Table','Table'[Name]<>"Hawaii"))

     

    Build a calculated table :

     

    Name = CALCULATETABLE(VALUES('Table'[Name]),FILTER('Table','Table'[Name]<>"Hawaii"))

     

    And filter the name of the map table by this slicer.

    If this reply still couldn't help you solve your problem, please show me sample tables like yours, and the result you want.

    Or you can provide me with your pbix file from your Onedrive for Business.

     

    Best Regards,

    Rico Zhou

     

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