Remove duplicate rows in Eazy BI report

Hi @Madhavi Pasapula

Thanks for posting your question!

I suggest switching to "Name" level member in the Fix Version dimension. It will group results by Fix Version name.

You can then create a new calculated measure using the following code:

TimestampToDate(Max(
  Filter(
    ChildrenSet(
      [Fix Version].CurrentHierarchyMember
    ),
    NOT IsEmpty([Fix Version].CurrentHierarchyMember.Get('Release date'))
),
  DateToTimestamp([Fix Version].CurrentHierarchyMember.Get('Release date'))
))

This formula will return the latest release date among the child versions of the current Fix Version member. Here's an example of my demo data report, showing only one line per Fix version and the release date:

I hope this helps!

Best,
Marita from support@eazybi.com