Count 2 descriptions in the same Column/Row

[gmazza76]

Good afternoon,

I have a data table that counts the individual questions in a table in PowerPivot, but I need to do a total of a few of the options in 1 as a "Success" and I am a bit stuck.
I have used the formula below to work out how many times "Direct" or "Q1" appears seperatley, but I now need to add them together as a total.

what would be the best way to do this as I am struggling a little bit and its driving me mad.

=if(DataTable[Outcome]="Success",CALCULATE(COUNTROWS(SourceDataTable), FILTER(SourceDataTable,SourceDataTable[Business]=DataTable[Business]),
FILTER(SourceDataTable,SourceDataTable[Brand]=DataTable[Brand]),
FILTER(SourceDataTable,SourceDataTable[Success]="Direct"),FILTER(SourceDataTable,SourceDataTable[Success]="1Question"),
FILTER(SourceDataTable,SourceDataTable[Week No]=WEEKNUM(today(),21)-1)),BLANK())

thanks in advance
Gavin

 

[gmazza76]

I have tried the following

=CALCULATE(COUNTROWS(SourceDataTable), FILTER(SourceDataTable,SourceDataTable[Business]=Call_Outcome[Business]&&FILTER(SourceDataTable,SourceDataTable[Brand]=Call_Outcome[Brand])
&&FILTER(AllGreenData,AllGreenData[Success]="S.Direct"&&FILTER(AllGreenData,AllGreenData[Success]="S.D.1 Questions"))))

But I get an error "The expression refers to multiple Columns. Multiple columns cannot be converted to a scalar value"

Any suggestions
Thanks