Compare filtered data sets

[manchesterbazza]

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

[manchesterbazza]

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]

HI @manchesterbazza,

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

Regards,

Xiaoxin Sheng