Return Minimum Value

[android1]

Hi,

This measure 

Missed Calls = CALCULATE(COUNTROWS(vw_PivotCancelledVisits),vw_PivotCancelledVisits[Visits_CancelReason] = "No C/W Available" || (vw_PivotCancelledVisits[Visits_CancelReason] = "No Show"))

returns either 1 or 2. 

When it is 2 I want it to be 1 instead. How can I do this?

[sokg · Accepted solution]

Try create this measure

NewMissedCalls= IF ( [Missed Calls] = 2 ; 1)

[Greg_Deckler · Accepted solution]

Missed Calls = CALCULATE(COUNTROWS(vw_PivotCancelledVisits),vw_PivotCancelledVisits[Visits_CancelReason] <> "No C/W Available" && (vw_PivotCancelledVisits[Visits_CancelReason] <> "No Show"))

[sokg · Accepted solution]

Try create this measure

NewMissedCalls= IF ( [Missed Calls] = 2 ; 1)