Set Analysis

[pratham39]

In ID = 1A there are two DOA Values,

that's why count (where difference of DOE-DOA less than 0)  is coming 2 ,  

Actually there should be 1 because that is only 1 ID which is 1A but due to two different dates ,

count is coming 2,

In KPI also I want to achieve same result that count should be 1.

Anyone can help?

Thanks

[BrunPierre]

Perhaps as below

FirstSortedValue(Aggr(Count(ID),ID,DOE,DOA), -DOA)

[pratham39]

Hi Sir,

First of all thanks for your response,

i want to display Count 1  when DOE - DOA <0 for ID = 1A, overall KPI Value should be 3 bcz there are 3 ID's

Please help

Thanks 

[BrunPierre]

=Count(Aggr(FirstSortedValue(ID,-DOA),ID,DOA,DOE))