Filtering data in a measure in power BI

[elmer]

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 measure can identify the values that contains a specific term. 

For example the column "Subject" has different values such as "Math 1", "Math 2", "Math 3" and also "Geography", "Physics", etc... What I need to do is to set the FILTER function in a way that it can identify all the values that contains the word "Math" (including "Math 1", "Math 2", "Math 3"...)

Any help?

Thanks!

[Anonymous · Accepted solution]

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]

Hi @Anonymous , It works! thanks!