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
navedkhan
Helper III
Helper III

Consider Duplicates (ONLY WITH HIGHEST VALUES or PICK ONE WHEN VALUES ARE SAME)

Hi All - i am looking for a solution by way of DAX code to simplify this problem;

 

i have a table which will have duplicates every time data is refreshed but we need to consider only following;

1) where 'Value' is maximum consider that only row in a table for reporting

2) where 'Value' is same then consider either of the values from rows in a table for reporting

3) above should work for each day only at a time

 

Table Name = Apple

43.PNG

 

Solved Table:

Capture.PNG

 

Kindly revert URGENTLY as i've to deploy this logic in a LIVE report!!!

 

@mussaenda @Anonymous 

 

 

 

 

1 ACCEPTED SOLUTION
mussaenda
Super User
Super User

With the data that you provided and the requirement that you stated,

I came up with this.

2019_10_03_08_36_08_.png

View solution in original post

1 REPLY 1
mussaenda
Super User
Super User

With the data that you provided and the requirement that you stated,

I came up with this.

2019_10_03_08_36_08_.png

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.