Forum Discussion
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'...
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], ",", "")) + 1You could further try using the above measure within a SUMX to iterate over one of your tmp tables and sum up the total.
Pete
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