Hi,
I want to calculate the number of days that specific users have between 3 and 4 ids as count.
I used the calculation below and created a table with the users (from dimensional table that is connected with our fact table where the IDs are found). When I filter one user from a filter then it gives back correct results for this specific user.
However when I do not apply any filter and see the list with users it is always 0.
Calculation:
Count({< [Date] = {"=Count( DISTINCT [ID]) >= 3 and Count(DISTINCT [ID]) <= 4"} >} DISTINCT [Date])
Does anyone have an input?
Thanks in advance