Forum Discussion

elmer's avatar
elmer
Icon for Helper I rankHelper I
7 years ago
Solved

Filtering data in a measure in power BI

Hi to everyone, I'm practicing the creation of measures in power bi to filter some data. I'm using the FILTER function, but I cannot understand how I can properly filter the data in a way that the m...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi elmer ,

     

    You can create a measure as below. Below measure will sum marks for all subjects which haging word "Math"

     

    Measure = CALCULATE(SUM(Sheet1[Marks]), FILTER(Sheet1, SEARCH("Math",Sheet1[Subject],,0)))
     
    If this solves your problem please accept thsi as solution and give khudos.
     
    Thanks.
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi elmer ,

 

You can create a measure as below. Below measure will sum marks for all subjects which haging word "Math"

 

Measure = CALCULATE(SUM(Sheet1[Marks]), FILTER(Sheet1, SEARCH("Math",Sheet1[Subject],,0)))
 
If this solves your problem please accept thsi as solution and give khudos.
 
Thanks.
  • elmer's avatar
    elmer
    Icon for Helper I rankHelper I
    7 years ago

    Hi Anonymous , It works! thanks!