Forum Discussion
giovissimo
Helper I
Helper IWildcard characters in filter expression
Hello, I have a table including all the students enrolled in a university course, and need to obtain the number of those who attended certain schools (identified by the prefix "school"). To do so, ...
giovissimo there is no concept of wildcard, you can do something like this
Students = CALCULATE([Students], FILTER(ALL(Course[SchoolName]),LEFT(Course[SchoolName],5)="School")) Students = CALCULATE([Students], FILTER(ALL(Course[SchoolName]),CONTAINSSTRING(Course[SchoolName],"School"))Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
giovissimoHelper I
Helper IThank you very much !