Countrows Query

[gmazza76]

Good afternoon,

I am using the calculation below to countrows which is working, but I could do with the calculation leaving a 0 if there is no total found.
Is there a way of doing this as its something I haven't looked at before as I need to run a pivot table off the data and need to show the heading even if there is no total.

if(Call_Outcome[Outcome]="Check1",CALCULATE(COUNTROWS(Sheet1), 
    FILTER(sheet1,sheet1[LB]=Sheet2[LB]),FILTER(sheet1,sheet1[Brand]=Sheet2[Brand]),
    FILTER(sheet1,sheet1[Outcome]="this"),
    FILTER(sheet1,sheet1[Week No]=WEEKNUM(today(),21)-1))

thanks in advance
Gavin

 

[gmazza76]

I have worked this out I think by adding +0 to the formula above

if(Call_Outcome[Outcome]="Check1",CALCULATE(COUNTROWS(Sheet1), 
    FILTER(sheet1,sheet1[LB]=Sheet2[LB]),FILTER(sheet1,sheet1[Brand]=Sheet2[Brand]),
    FILTER(sheet1,sheet1[Outcome]="this"),
    FILTER(sheet1,sheet1[Week No]=WEEKNUM(today(),21)-1))+0

 

[GraH]

You can also use this Pivot Setting