Forum Discussion

Jeyeline's avatar
Jeyeline
Icon for Helper III rankHelper 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!