I have a list of names separated by Break element (<br> in html format).
I need to output the count of this list but I can’t find a way to count them
Field returned - “John Smith <br> Peter Johnson <br> Mark Anderson” (converted from html to plain format)
Outcome needed - 2
Basically, do the count of how many names(-1) are in 1 field.
Is this possible to do with MDX?
I’ve tried with Val, ExtractString and with Replace but I don’t get the desired result
Appreciate any help on this.