All days in date not working
I have a count of unique values and use (value,ALL(days_in_date)) function but is still being affected by my blox date filter. I need a way to calculate an all time formula for one column that is not...
Forum Discussion
After playing with it some more it seems the date filter is really on the Department column and for now I cannot figure out a way to list all departments since you cannot do ALL() on a non aggregate field. The overall goal would be to have all departments listed then a column for Patient User ID that is affected by date filter then another column for All Time Patient User ID that is not affected by date filter and always shows the entire count.
Another thing you can try is to force (one of ) the measures to use a value from the table containing the 'Department' column. That could also be a dummy number added in data prep (add a column of 1's). Or if your Department names are unique, you can use their distinct count.
So something like <your formula>*MAX(dummy column) or <your formula>*COUNT(department). Both of these should multiply by 1, resulting in the actual value of your formula. But now the formula has a component from your columns table.
Or if you really want to be sure the number doesn't have an *actual* influence: <your formula> + 0*Count(department)
