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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.