Either enforce date padding by setting
the Show Missing Values flag on your Date pill
and using ZN( COUNTD( [Id] ) ) as a Measure,
or Join with the daily calendar table ON Date
to avoid date padding and ZN() altogether.
Thank you for solusion!
Just one question more: is there any chance to put some conditions into the formula? E.g. count more then 2 non-active days or between x and y?
Yes, It can be done..Just give some example