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
BharathM
Helper IV
Helper IV

Remove Duplicate Id and retrieve max

Hi Everyone
I need a measure to retreve the max of ID based on max column and date 

BharathM_0-1679054400376.png


I have ID,MAX,DATE columns here my requirement is to remove the duplicate ID's based on max column

should show only the max of id and date 

Desired Output 

BharathM_2-1679054700079.png


But one more thing i want to remove the max column in visual please give me suggestion for that 

 

1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

Hi @BharathM 
Please place the following measure in the filter pane of the table visual, select "is not blank" and apply the filter

FilterMeasure =
VAR MaxMax =
    CALCULATE ( MAX ( 'Table'[MAX] ), ALLEXCEPT ( 'Table', 'Table'[ID] ) )
RETURN
    COUNTROWS ( FILTER ( 'Table', 'Table'[MAX] = MaxMax ) )

 

View solution in original post

2 REPLIES 2
tamerj1
Super User
Super User

Hi @BharathM 
Please place the following measure in the filter pane of the table visual, select "is not blank" and apply the filter

FilterMeasure =
VAR MaxMax =
    CALCULATE ( MAX ( 'Table'[MAX] ), ALLEXCEPT ( 'Table', 'Table'[ID] ) )
RETURN
    COUNTROWS ( FILTER ( 'Table', 'Table'[MAX] = MaxMax ) )

 

Thank You so much dude its working 
Again Thanks for speed reply

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