Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
deb_power123
Helper V
Helper V

DAX calculation for removal of duplicate rows

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:

SchoollocationAveragemarks
ABCIndia90
ABCDelhi90
DEFIndia89
DEFDelhi89
DEJIndia75
DEJGoa75
DEMIndia97
DEMGoa97

 

Expected Output :

SchoollocationAveragemarks
ABCDelhi90
DEFDelhi89
DEJGoa75
DEMGoa97

 

Kind regards

Sameer

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Filter Location Column from the power query.

vairag99_0-1648207806697.png

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

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

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Filter Location Column from the power query.

vairag99_0-1648207806697.png

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

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

Awesome

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors