Forum Discussion
Solved
date roll up issue
I'm reaching out here after about 5 days of tyring to unpick the issue myself with lots of rebuilds, googling, different measures, calculated columns etc and still failing. I have data in a form...
In your eligible measure you are only removing filters from the 'Date'[Date] column, which is why it works when you have the date column on the axis. You need to remove filters from the entire date table,
Eligible = CALCULATE ( DISTINCTCOUNT ( data[PERSON_ID] ), data[IS_ELIGIBLE] = TRUE (), data[IS_ACTIVE] = TRUE (), ALL ( 'Date' ) )
THANK YOU SO MUCH!! I'm pretty sure what you've told me I saw in many a googling over the last week but clearly didn't see the wood for the trees.