Set analysis shows different results when filter applied
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.