sumx filter

[MartinBT]

Hi PowerBI users, 

Im fairly new at PowerBI so I hope someone can help out abit. 

I have a dataset that contains the following columns: 

Hours

Issue_key

 

I want to create a new calculated column that sums up all hours that is not logged on a issue_key that starts with IW 

In the screenshot the SUM would be 0,25 

I figure I need to use the SUMX Filter, but I am unsure how to structure it. 

Thanks

[himanshu56 · Accepted solution]

Hi @MartinBT,

First create a new column
test = LEFT(Table1[issue key],2)

then create a measure

Measure = SUMX(Table1,IF(Table1[test] <> "IW",(Table1[hours]),0))

Please see the attached snapshot

Thanks,

Himanshu

[MartinBT]

Great solution @himanshu56

Thanks for helping out, it works like a charm. I didnt think of extracting the IW first in a column.