cancel
Showing results for
Did you mean:
Highlighted
Regular Visitor

## Mutliple Filters in same column

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
3 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted Community Support

``````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.

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

Proud to be a Super User!

Highlighted Super User IV

@Sandeep_rai , Try like

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

Proud to be a Super User!

3 REPLIES 3
Highlighted Community Support

``````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.

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

Proud to be a Super User!

Highlighted Super User IV

@Sandeep_rai , Try like

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

Proud to be a Super User! Announcements #### Power Platform Community Conference

Check out the on demand sessions that are available now! #### Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella. Top Solution Authors
Top Kudoed Authors
Users online (1,656)