cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Community Support

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

View solution in original post

Highlighted
Super User I
Super User I

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




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

Highlighted
Super User IV
Super User IV

@Sandeep_rai , Try like

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


Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

3 REPLIES 3
Highlighted
Community Support
Community Support

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

View solution in original post

Highlighted
Super User I
Super User I

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




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

Highlighted
Super User IV
Super User IV

@Sandeep_rai , Try like

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


Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

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