Forum Discussion

edcdcpowerbi's avatar
edcdcpowerbi
Icon for Helper I rankHelper I
5 years ago

Help Filtering Country table countries by continent

I have a table name 'Countries', in this table are two columns 'Country' and 'Continent'.    I want to create a measure which filters these countries for the continents Europe and Africa.    I am...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

edcdcpowerbi , Create the measure below and use that with the country in visual

 

countrows(filter(Table, Table[Continent] in { "Europe" , "Africa"}))

  • edcdcpowerbi's avatar
    edcdcpowerbi
    Icon for Helper I rankHelper I
    5 years ago

    Hi, thanks for helping. Is there a way this can be done in a single measure rather than having to add countries to a visual with this measure? I am hoping to have a single measure with lists all the filtered countries.