Forum Discussion
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 slice...
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
HI manchesterbazza,
It is hard to help with your scenario without any sample data and formulas.
Regards,
Xiaoxin Sheng