Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Multiple Selection using selected value from same column of a table

There is a column named Country with some values and there is GDP column for each country. There is a column for 'export & import' between the countries. There is a selection slicer provided for 'export&import' , 'country'. The issue is when multiple countries are selected & the 'export & import' is selected ,it has to show their GDPs as well as their 'export & import' values. This data needs to be shown on a Line chart with Year on the X-axis.

Need Help

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , You need to create a measure which checks if there is more then one value, then show the values 

     

    Measure =

    var _cnt = countrows(allselected(table[Countries]))

    return

    if(_cnt=1, blank(), [GDP measure])

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi amitchandak, it has to return both the GDP value and 'export&import' value on selecting the country and  'export&import' from the slicers

  • smpa01's avatar
    smpa01
    Community Champion
    4 years ago

    Anonymous  provide sample data and expected output.

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Community Support
    4 years ago

    Hi, Anonymous 

     

    What's your'export & import' data like? Is there any problem with placing the column to visual directly?

     

    Best Regards,
    Community Support Team _ Janey