Remove duplicates from calculated measures

Questions & Answers
1

Hi, I am building to get number of releases per quarter per release type (user defined field) and it looks below

image
image691×673 22.7 KB

Problem is it displays duplicate rows. I understand that those are for different centres but I just want each version to be displayed only once. Version Release in Period is connected to Time Dimension. I am not sure how to do it. Can anybody help please?

2

Any help on this issue is greatly appreciated

3

Hi @mpasapula,

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.

image
image526×1006 42 KB

You can then create a new calculated measure (Calculated measures) 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:

1784×1230 228 KB

I hope this helps!

Best,
Marita // support@eazybi.com

4

Thank you Marita, it worked.

Thanks
Madhavi

1 Like