Forum Discussion
How to filter out rows from calculation
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...
Result measure =
SUMX ( FILTER ( 'Table', NOT ( 'Table'[B] IN { "D", "" } ) ), 'Table'[A] )https://www.dropbox.com/s/ou6ab6bsvhri2pe/harriet.pbix?dl=0
Jihwan_Kim
Super User
Super User
Result measure =
SUMX ( FILTER ( 'Table', NOT ( 'Table'[B] IN { "D", "" } ) ), 'Table'[A] )
https://www.dropbox.com/s/ou6ab6bsvhri2pe/harriet.pbix?dl=0