Mutliple Filters in same column

[Sandeep_rai]

Hello All, 

I am trying to calculate sum in column A depending on the multiple values in column B. To illustrate below is an example

Column A   Column B

100                 C1

200                  D1

300                  AB1

I am trying to calculate sum in column A only for values "C1" & "D1" but i am not able to do it. 

Below is the formula i am writing but is there any way i can put multilple filter in there

NAV CY = CALCULATE(SUM(Table]),FILTER(table,(table columnname"C1"))

Can anyone please help me with where i am going wrong and how can i correct it

[v-yuta-msft · Accepted solution]

@Sandeep_rai ,

Modify your measure as below:

NAV CY =
CALCULATE (
    SUM ( Table[Column A] ),
    FILTER ( Table, Table[Column B] = "C1" || Table[Column B] = "D1" )
)

Community Support Team _ Jimmy Tao

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

[vanessafvg · Accepted solution]

NAV CY =
CALCULATE (
    SUM ( [value] ),
    FILTER ( table, table[columnname] = "C1" || table[columnname] = "DW" )
)

[amitchandak · Accepted solution]

@Sandeep_rai , Try like

Measure =CALCULATE (  SUM ( Table[Column A] ), FILTER ( Table, Table[Column B] in { "C1" , "D1" } ))

[vanessafvg · Accepted solution]

NAV CY =
CALCULATE (
    SUM ( [value] ),
    FILTER ( table, table[columnname] = "C1" || table[columnname] = "DW" )
)

[v-yuta-msft · Accepted solution]

@Sandeep_rai ,

Modify your measure as below:

NAV CY =
CALCULATE (
    SUM ( Table[Column A] ),
    FILTER ( Table, Table[Column B] = "C1" || Table[Column B] = "D1" )
)

Community Support Team _ Jimmy Tao

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