Addition two columns who have filters on it

[ItSupportElm]

Hello,

I have two calculate columns who have filters on it : 

1 :     

 2 : 

then i want to additon this two new column and keep there filters, but i dont know how to do that.

I even try with this formule : 

Mesure 2 = CALCULATE(

COUNT(Client[IdClient]);  

FILTER(Client;Client[FlagTiersPayant] = "y");

FILTER(Client;Client[VIP] = "y"))

but it return me a wrong result...

If someone can help me please.

Thank you for the future answer.

Great day

[Anonymous]

Instead of creating columns Create measure with your same formula Test and  TEST2 and then create one more below measure 

ADDition= Test+ Test2

[az38]

Hi @ItSupportElm 

try

Mesure 2 = CALCULATE(
COUNT(Client[IdClient]);  
FILTER(
Client;
AND(Client[FlagTiersPayant] = "y";Client[VIP] = "y")
)
)

or AND replace to OR

do not hesitate to give a kudo to useful posts and mark solutions as solution

LinkedIn