Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
Hi @elmer ,
You can create a measure as below. Below measure will sum marks for all subjects which haging word "Math"
Hi @elmer ,
You can create a measure as below. Below measure will sum marks for all subjects which haging word "Math"
Hi @Anonymous , It works! thanks!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |