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 ...
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

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.