Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Image 1
Image 2
In image 1 and 2 C1 is same measure, but without field it is giving C1 and adding any field is giving a table like Image 2(total of measure is same in all the cases).
Help Please
Not giving correct results
post some sample data
C1 is my expression C2 is yours
Now for those 2 Eid's
for the eid ending with 092 , there is expiry between required dates and it is not getting created again
so it needs to counted,
Similarly for eid ending with 152 the last row satisfies the criteria and no other row disqualify that so it should also be counted but both of these are not counted by your expression.
Also my problem is that my expression isnt working properly without dimension or when dimension is eid.
can you post a larger sample in excel?
or try the same expression but create a new unique field to identify each record separately
,Eid&CreatedDate as Eid_unique
=Count({<Eid_unique=
p({<[Expiry Date]={">=$(=44652)<=$(=44742)"}>-<[Created Date]={">=$(=44742)<=$(=44834)"} >} Eid_unique)
>}distinct Eid)