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.
Hello everyone,
for one string filter the following works:
Solved! Go to Solution.
Hii,
Does this work?
NewColumn = CALCULATE(DISTINCTCOUNT(table[ID]),FILTER(table,CONTAINSSTRING(table[OPTIONS],"String01")||CONTAINSSTRING(table[OPTIONS],"String02")))
Hope this helps.
Hii,
Does this work?
NewColumn = CALCULATE(DISTINCTCOUNT(table[ID]),FILTER(table,CONTAINSSTRING(table[OPTIONS],"String01")||CONTAINSSTRING(table[OPTIONS],"String02")))
Hope this helps.
Hi @KPME
For the second column use AND (&&), OR (||) operator insted of "+" sign based on your requirement
If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!
Hey! this doesn't result in any errors, however it does result in an error in the visual which I can't explain 😞
may be you can provide sameple data without sensitive information so i can able to support you further.
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 |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |