topic How to filter out rows from calculation in DAX Commands and Tips

How to filter out rows from calculation

Anonymous — Tue, 29 Jun 2021 10:27:36 GMT

Hi all,

I was wondering if anybody could help me with what I think should be achieved very simply in DAX - I just can't find the right function!

I have two columns of data, let's say Column A and Column B. I'd like to SUM Column A based on the values in Column B.

With the example data below, I'd like to sum Column A for all values in Column B EXCLUDING blanks and 'Don't know'. So my total sum should be only for 'yes' and 'no' and therefore be 65. So my question is: how do I exclude specific values in a column from a calculation?

Any help much appreciated!

Thanks 😊

Re: How to filter out rows from calculation

CNENFRNL — Tue, 29 Jun 2021 10:51:32 GMT

Excel, our oldie but goodie does the trick with ease,

Re: How to filter out rows from calculation

Anonymous — Tue, 29 Jun 2021 10:59:40 GMT

Thanks for this, but I need to do this within Power BI using a measure

Re: How to filter out rows from calculation

Jihwan_Kim — Tue, 29 Jun 2021 11:18:54 GMT

Result measure =
SUMX ( FILTER ( 'Table', NOT ( 'Table'[B] IN { "D", "" } ) ), 'Table'[A] )

https://www.dropbox.com/s/ou6ab6bsvhri2pe/harriet.pbix?dl=0