Forum Discussion

manchesterbazza's avatar
manchesterbazza
New Member
8 years ago

Compare filtered data sets

Hi

I have a table which is imported from SQL, one of the columns is if task has been processed by Team A = 0 or Team B = 1

I have set my filter based on team B therefore choosing 1 as the slicer

 

What i want to be able to do is cmopare the % of Team A against the full total of Team A and B combined

i.e. Team A and B combined shows 1000 tasks completed, what percentage of those were Team A and what percentage Team B?

 

Im sure this is straightforward but i would like my current visials no the page to remain as they are going off some filters but the percentage totals be calculated and not touch the visual

 

hope i make sense

 

Need Help

2 Replies

  • manchesterbazza's avatar
    manchesterbazza
    New Member
    8 years ago

    See below

     

    If i do a table visual, i can select the count of the all tasks table and filtered it to show the totals for Team A and Team B using dont summarize which shows the following visual

     

    There already is a column for the processed by Team B as this is an automated process which is captured in SQL, i want to try and create a measure in order to get the 753711 figure which is basically what remains when team Bs total of 11283 is subtracted from the grand total of 764994

     

    Im sure i am missing something obvious but i am struggling to find how i can get Team A's total

     

    Thanks

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      HI manchesterbazza,

       

      It is hard to help with your scenario without any sample data and formulas.

       

      Regards,

      Xiaoxin Sheng