Forum Discussion

android1's avatar
android1
Post Patron
8 years ago
Solved

Return Minimum Value

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?

Need Help
  • sokg's avatar
    sokg
    8 years ago

    Try create this measure

     

     

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

  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago
    Missed Calls = CALCULATE(COUNTROWS(vw_PivotCancelledVisits),vw_PivotCancelledVisits[Visits_CancelReason] <> "No C/W Available" && (vw_PivotCancelledVisits[Visits_CancelReason] <> "No Show"))

2 Replies

  • sokg's avatar
    sokg
    Solution Supplier
    8 years ago

    Try create this measure

     

     

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

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    8 years ago
    Missed Calls = CALCULATE(COUNTROWS(vw_PivotCancelledVisits),vw_PivotCancelledVisits[Visits_CancelReason] <> "No C/W Available" && (vw_PivotCancelledVisits[Visits_CancelReason] <> "No Show"))