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"),FILT...
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})))

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