Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Incorrect Formula

 

Hi,

 

What is wrong in this formula?

 

 

Feature = CALCULATE(DISTINCTCOUNT('devops-query-spr2'[Work Item Id]),FILTER('devops-query-spr2','devops-query-spr2'[Work Item Type] = "Feature"),FILTER('devops-query-spr2','devops-query-spr2'[Work Item Id] <> {"9563","9564","9565","9566","9531"}))
 

Regards,

Himanshu

Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Try like

    Feature = CALCULATE(DISTINCTCOUNT('devops-query-spr2'[Work Item Id]),FILTER('devops-query-spr2','devops-query-spr2'[Work Item Type] = "Feature" && not('devops-query-spr2'[Work Item Id] in {9563,9564,9565,9566,9531})))

5 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , Try like

     

    Feature = CALCULATE(DISTINCTCOUNT('devops-query-spr2'[Work Item Id]),FILTER('devops-query-spr2','devops-query-spr2'[Work Item Type] = "Feature" && not('devops-query-spr2'[Work Item Id] in {"9563","9564","9565","9566","9531"})))

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      It still gives error:

       

       

      But my issue is resolved using the values seperately.

       

      Regards,

      Himanshu

      • amitchandak's avatar
        amitchandak
        Super User
        5 years ago

        Anonymous , Try like

        Feature = CALCULATE(DISTINCTCOUNT('devops-query-spr2'[Work Item Id]),FILTER('devops-query-spr2','devops-query-spr2'[Work Item Type] = "Feature" && not('devops-query-spr2'[Work Item Id] in {9563,9564,9565,9566,9531})))

  • PC2790's avatar
    PC2790
    Community Champion
    5 years ago

    Hey,

    Try this:

    Feature = CALCULATE(DISTINCTCOUNT('devops-query-spr2'[Work Item Id]),FILTER('devops-query-spr2','devops-query-spr2'[Work Item Type] = "Feature" && 'devops-query-spr2'[Work Item ID] <> {9563,9564,9565,9566,9531}))

    See if it works for you

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Even this is giving error:

       

       

      Not sure why but when I write the code seperately it works:

       

      Feature = CALCULATE(DISTINCTCOUNT('devops-query-spr2'[Work Item Id]),FILTER('devops-query-spr2','devops-query-spr2'[Work Item Type] = "Feature" && 'devops-query-spr2'[Work Item Id] <> {9563} && 'devops-query-spr2'[Work Item Id] <> {9564} && 'devops-query-spr2'[Work Item Id] <>{9565} && 'devops-query-spr2'[Work Item Id]<>{9566} && 'devops-query-spr2'[Work Item Id]<> {9531}))
       
      Regards,
      Himanshu