Forum Discussion

MartinBT's avatar
MartinBT
Frequent Visitor
9 years ago
Solved

sumx filter

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

Need Help
  • himanshu56's avatar
    himanshu56
    9 years ago

    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

2 Replies

  • himanshu56's avatar
    himanshu56
    Resolver II
    9 years ago

    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's avatar
      MartinBT
      Frequent Visitor
      9 years ago

      Great solution himanshu56


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