Forum Discussion

Jeyeline's avatar
Jeyeline
Helper III
2 years ago
Solved

Creating visualisation by summing the counts of two outputs

Hello Team,    We are fetching data from Azure DevOps analytic view where we have certain fields like Field Value Team Internal, External Reference Number Null, NA, unique IDs Null...
Need Help
Tips and Tricks
  • Jeyeline's avatar
    Jeyeline
    2 years ago

    Hi Anonymous ,

     

     Thanks for the reply. I tried this and I customized it 

    WorkItem1= CALCULATE (
         COUNTROWS( 'OKR'),  
                  'OKR'[Team]="External"
             )

     

     WorkItem2= CALCULATE (

         COUNTROWS( 'OKR'),  
                  'OKR'[Reference#] <> ""
             )

     

     And I combined the output by adding both to get the overall.

     

    Thanks!

     
lbendlin's avatar
lbendlin
Super User
2 years ago

Teach your users how to operate the filter pane.

Jeyeline's avatar
Jeyeline
Helper III
2 years ago

Hello lbendlin ,

 

We cannot accomplish this via the filter pane. Applying the first filter automatically filters the first level of records, hence there is no use in applying the second filter.

Our expectation is related to getting two separate outputs and combining both.