Incorrect Formula

[Anonymous]

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

[PC2790]

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]

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

[amitchandak]

@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]

It still gives error:

But my issue is resolved using the values seperately.

Regards,

Himanshu

[amitchandak · Accepted solution]

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