Creating a measure to calculate as per logic..

[Anonymous]

If i calculate 1st june then my logic will be count of (1st to 7th) result will show in 1st june ..similarly 2nd june count will be ( 2nd june to 8th june) as per above output table..

i need a measure for this..

Thanks !!

[Anonymous]

@Anonymous Hello,

For above image 2nd table result should not be blank, it is counting running date wise.

as per dax if some value is not there againt date , it is showing blank instead of counting ...

[Anonymous]

Thank you so much buddy ...Its helps me a lot....

[Anonymous]

if anyone trying to this getting any confusion please drop a message here....

[Anonymous · Accepted solution]

Hi @Anonymous ,

I suggest you to create a measure by this code.

Measure = 
CALCULATE(COUNT('Table'[Value]),FILTER(ALLEXCEPT('Table','Table'[ID]),'Table'[Value]<>BLANK()&&'Table'[DT]>=MAX('Table'[DT])&&'Table'[DT]<=MAX('Table'[DT])+6))

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.