Forum Discussion

jak8282's avatar
jak8282
Helper III
2 years ago
Solved

Wee bug found

When using the not(isblank) function within a calculate it doesnt seem use the other filters in the calculate.

 

Had some wierd returns.

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi jak8282 ,

     

    Try to modify your formula like below: In this modified expression, we use Evaluation[Scorecard] <> "other" to filter records where the Scorecard column is not equal to "other".

    QMS Procedural Pass Score1 = 
CALCULATE(
    COUNT(Evaluation[Date]),
    Evaluation[Process Result] = "Pass",
    Evaluation[Scorecard] <> "other",
    USERELATIONSHIP('Date'[Date], Evaluation[Date])
)

     

    Best Regards,
    Adamk Kong

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi jak8282 ,

     

    Try to modify your formula like below: In this modified expression, we use Evaluation[Scorecard] <> "other" to filter records where the Scorecard column is not equal to "other".

    QMS Procedural Pass Score1 = 
CALCULATE(
    COUNT(Evaluation[Date]),
    Evaluation[Process Result] = "Pass",
    Evaluation[Scorecard] <> "other",
    USERELATIONSHIP('Date'[Date], Evaluation[Date])
)

     

    Best Regards,
    Adamk Kong

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    2 years ago

    jak8282 Well, CALCULATE after all... Any chance you can provide more information so that the problem can be recreated?

    • jak8282's avatar
      jak8282
      Helper III
      2 years ago

      It was with code

       

      QMS Procedural Pass Score =
      CALCULATE(
      COUNT(Evaluation[Date]),
      Evaluation[Process Result] = "Pass",
      NOT(Evaluation[Scorecard])= "other",
      USERELATIONSHIP('Calendar Date'[Date],Evaluation[iDayID]))

       

      never knew calculate was was to use..

       

      With the NOT it was bringing back all the scorecards

       

      scorecard 1   |     72%

      scorecard 2   |     72%

      scorecard 3   |     72%

      scorecard 4  |     72%

       

      However with the blank in the filter section instead it brought it back correctly

       

      scorecard 3 |  72%

       

      HTH