DAX calculation for removal of duplicate rows

[deb_power123]

Hi,

For the source table below , I have repeated rows one for India and another for Delhi location .

Another for India and Goa location. 

I want to hide all those rows with India(marked in bold in the below table) location and want to only keep the rows with Delhi and Goa location .I have many enteries like this so it should be don via some DAX. Please suggest.

Source Indput:

School	location	Averagemarks
ABC	India	90
ABC	Delhi	90
DEF	India	89
DEF	Delhi	89
DEJ	India	75
DEJ	Goa	75
DEM	India	97
DEM	Goa	97

Expected Output :

School	location	Averagemarks
ABC	Delhi	90
DEF	Delhi	89
DEJ	Goa	75
DEM	Goa	97

Kind regards

Sameer

[Anonymous · Accepted solution]

Filter Location Column from the power query.

Then save and close the power Query editor.
2. You Can Use DAX Also

New_Table = FILTER('Table','Table'[Location]<>"India")

[deb_power123]

Awesome