Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi,
I will try and explain this in the best way possible.
I have some columns that within each row they might have different options which are semicoloun separated.
Take for example the below coloumn - Row one contains two select options Private drains cleaned and GM UPGDARED....
within the hightlight row, I only just want to count "GM UPGRADED following....
My question is, how can I count item semicolon separted within a row? If that makes any sense
I have tried the below but it' not returning me the correct result
Solved! Go to Solution.
@ukare1996 , try like
Monitor 1 - TEST =
COUNTROWS(
FILTER('Network (Test)',
Containsstring('Network (Test)'[Monitor 1 - Action] , "GM installed following NPO visit/advice")
|| Containsstring('Network (Test)'[Monitor 1 - Action] , "GM (ADDITIONAL) installed following NPO visit/advice")
|| Containsstring('Network (Test)'[Monitor 1 - Action] ,"GM UPGRADED following NPO visit/advice")
))
CONTAINSSTRING and CONTAINSSTRINGEXACT: https://www.youtube.com/watch?v=XbgLGDvWdWQ&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=44
Thank you, I honestly dont know why I didnt think of doing it this way 🙂
Much appreciated
@ukare1996 , try like
Monitor 1 - TEST =
COUNTROWS(
FILTER('Network (Test)',
Containsstring('Network (Test)'[Monitor 1 - Action] , "GM installed following NPO visit/advice")
|| Containsstring('Network (Test)'[Monitor 1 - Action] , "GM (ADDITIONAL) installed following NPO visit/advice")
|| Containsstring('Network (Test)'[Monitor 1 - Action] ,"GM UPGRADED following NPO visit/advice")
))
CONTAINSSTRING and CONTAINSSTRINGEXACT: https://www.youtube.com/watch?v=XbgLGDvWdWQ&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=44
User | Count |
---|---|
21 | |
19 | |
12 | |
9 | |
8 |
User | Count |
---|---|
31 | |
27 | |
15 | |
13 | |
10 |