Forum Discussion

MightyRabbit's avatar
MightyRabbit
Frequent Visitor
3 years ago
Solved

How to count the measure

Dear all,  I have a table name "Sheet1" like this: Series No F88 1234 F88 1235 F88 1236 F88 1237 F88 1240 A25 3456 A25 3457 A25 3459 A25 3460   I'...
Need Help
  • BA_Pete's avatar
    BA_Pete
    3 years ago

    Hi MightyRabbit ,

     

    You could try an additional measure something like this to count at the row level:

     

    _noofMissing =
LEN([Missing_No]) - LEN(SUBSTITUTE([Missing_No], ",", "")) + 1

     

     

    You could further try using the above measure within a SUMX to iterate over one of your tmp tables and sum up the total.

     

    Pete

MightyRabbit's avatar
MightyRabbit
Frequent Visitor
3 years ago

Hi BA_Pete ,

Thank you very much, it helps 🙂 Could you please elborate how could I use the SUMX against the tmp table, I have above, it seems that it only take the exisiting table "Sheet1" value only. 

Thanks,