Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Using OR function in a CALCULATE statement

Good afternoon experts, Hoping someone can highlight my error in the below Measure.  Essesntially I need a count of ID's between two dates, within a KPI value (14). Where I fall over is the OR (||)...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    Hi,

    I am not sure how your datamodel looks like, but please try the below whether it suits your requirement.

     

    KPI =
CALCULATE (
    DISTINCTCOUNT ( 'Table 1'[ID] ),
    FILTER (
        ALLSELECTED ( 'Table 1' ),
        (
            'Table 1'[Status] = "Closed"
                || ISBLANK ( 'Table1'[column 2] )
        )
            && 'Table 1'[Days between] <= 14
            && 'Table 1'[Date Received] >= DATE ( 2022, 7, 1 )
            && 'Table 1'[Date Received] <= DATE ( 2023, 6, 30 )
            && 'Table 1'[Team] = "Team awesome"
    )
)
tamerj1's avatar
tamerj1
Community Champion
3 years ago

Hi Anonymous 

please try

KPI =
CALCULATE (
    DISTINCTCOUNT ( 'Table 1'[ID] ),
    FILTER (
        'Table 1',
        'Table 1'[Status] = "Closed"
            || 'Table 1'[column 2] = BLANK ()
                && 'Table 1'[Days between] <= 14
                && 'Table 1'[Date Received] >= DATE ( 2022, 7, 1 )
                && 'Table 1'[Date Received] <= DATE ( 2023, 6, 30 )
                && 'Table 1'[Team] = "Team awesome"
    )
)