topic Re: Using OR function in a CALCULATE statement in DAX Commands and Tips

Using OR function in a CALCULATE statement

Anonymous — Mon, 17 Oct 2022 02:14:10 GMT

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 (||) line.

I only want to count where a sale is "CLOSED" OR if another value is isblank.

Is this the correct way of deriving this count?

Cheers

Phil

KPI = CALCULATE

(DISTINCTCOUNT('Table 1'[ID]),

'Table 1'[Status] = "Closed" || 'Table1' [column 2] isblank,

'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"

Re: Using OR function in a CALCULATE statement

Jihwan_Kim — Mon, 17 Oct 2022 03:23:40 GMT

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" ) )

Re: Using OR function in a CALCULATE statement

tamerj1 — Mon, 17 Oct 2022 03:24:00 GMT

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" ) )

Re: Using OR function in a CALCULATE statement

wdx223_Daniel — Mon, 17 Oct 2022 03:42:24 GMT

KPI = CALCULATE

(DISTINCTCOUNT('Table 1'[ID]),

FILTER(ALL('Table 1'[Status],'Table1' [column 2]), '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"