DAX for sum with multiple where conditions

[Anonymous]

Hello,

I am trying to write a DAX for sum of multiple where conditions. For ex:

CALCULATE(SUM(W_R[T]),W_R[S] = "C" || W_R[S] = "C_S" || W_R[S]  = "R" || W_R[S] = "V").  The DAX is running but it's not showing me the correct number. Can some one please tell me where I am wrong?

[Anonymous · Accepted solution]

Hi  @Anonymous ,

I created some data:

If you want to put measure and other fields together, you need to add an all()

Create measure.

add_all = CALCULATE(SUM(W_R[T]),FILTER(ALL(W_R), W_R[S] = "C" || W_R[S] = "C_S" || W_R[S]  = "R" || W_R[S] = "V"))

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Fowmy]

@Anonymous 
Please provide more details and explain your data and the expcted results