count with multiple conditions

[#1]

I have this condition :

for a dimension brand:

Count(distinct if ( InvoicedQty>Target and YYYY=vYear ,Shop))

I want to count shops that reach the target for all branches.

Can someone help me ?

[#2]

I'd suggest trying the If() outside the Count() function. Something like the following:

=If((InvoicedQty>Target) and (YYYY=vYear), Count(distinct Shop), 0)

I hope that is helpful. Best regards,

James

[#3]

Hi James,

My expression is working but what I would like to have is an additional line with the number shops for which the target is reached for all brands.

I have :

Brands	reach target
Brand 1	10 shops
Brand 2	5 shops

I Would like to have:

Brands	reach target
Brand 1	10 shops
Brand 2	5 shops
reach target for brand 1 and 2	3 Shops