Forum Discussion
Pbiuserr
Post Prodigy
Post ProdigyCOUNTROWS counting wrong
Hello, I have a table as a result of the drillthrough like down below ID Country Gender Seniority Company ID1 COUNTRY1 M Company1 ID2 COUNTRY2 F 7 Company2 ID3 COUNT...
I believe you could duplicate the ID column, extract the first 2 letters & you will be left with just the numbers. Then try COUNTROWS on that column. It might be getting stuck on ID being at the beginning of every value & considering them all the same. Try that and let me know.
PbiuserrPost Prodigy
Post ProdigyHey
In reality my ids are just numbers, that was on purpose of dummy data