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
Excel, our oldie but goodie does the trick with ease,
Thanks for this, but I need to do this within Power BI using a measure