Forum Discussion
Priority Open Bug Pull
Hi, I am trying to create a data pull for the number of "New" and "Active" bugs that are priority 1 and or have been tagged "blocking" from DevOps. How would I go about this succinctly? Tha...
Hi I tried both the below and neither has worked:
Source = ('Bugs - Resolved')
NewAndActiveBugs = ('Bugs - Resolved'[State]="New","Active"),
Priority1OrBlockingBugs = ('Bugs - Resolved'[Priority]="1") or ('Bugs - Resolved'[Tags]="Blocking")
Or
Open Bugs =
VAR _ACTIVEBUGS = CALCULATE(COUNTROWS('Bugs - Resolved'),KEEPFILTERS('Bugs - Resolved'[State]="Active"))
VAR _NEWBUGS = CALCULATE(COUNTROWS('Bugs - Resolved'),KEEPFILTERS('Bugs - Resolved'[State]="New"))
RETURN CALCULATE((_NEWBUGS)+(_ACTIVEBUGS))
RETURN KEEPFILTERS('Bugs - Resolved'[Priority]="1") OR KEEPFILTERS('Bugs - Resolved'[Tags]="Blocking")
Any ideas?