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

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