Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

DAX help - Less than or Blank

Hi geniuss!!!   I'm trying to create a measure that I'll be using against a calendar table to plot number of active contacts at any given time, but I'm tearing my hair our with some of these measur...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi Anonymous 
    You may try

    Members TEST =
VAR CurrentDate =
    MAX ( '-Calendar'[Date] )
RETURN
    CALCULATE (
        DISTINCTCOUNT ( 'CE vwContact (2)'[Rics_contactno] ),
        'CE vwContact (2)'[Rics_ElectionDate] >= CurrentDate,
        OR (
            'CE vwContact (2)'[Rics_LapsedDate] <= CurrentDate,
            'CE vwContact (2)'[Rics_LapsedDate] = BLANK ()
        )
    )
tamerj1's avatar
tamerj1
Community Champion
4 years ago

Hi Anonymous 
You may try

Members TEST =
VAR CurrentDate =
    MAX ( '-Calendar'[Date] )
RETURN
    CALCULATE (
        DISTINCTCOUNT ( 'CE vwContact (2)'[Rics_contactno] ),
        'CE vwContact (2)'[Rics_ElectionDate] >= CurrentDate,
        OR (
            'CE vwContact (2)'[Rics_LapsedDate] <= CurrentDate,
            'CE vwContact (2)'[Rics_LapsedDate] = BLANK ()
        )
    )