Forum Discussion

Randomlee's avatar
Randomlee
New Member
11 months ago
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...
Need Help
  • johnt75's avatar
    johnt75
    11 months ago

    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' )
)
johnt75's avatar
johnt75
Super User
11 months ago

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' )
)
Randomlee's avatar
Randomlee
New Member
11 months ago

thank you thank you thank you! I'm so stupid! you're a life saver.