There might be some simple explanation but i cannot figure it out.

  • @ArtVandelay
    link
    English
    24
    edit-2
    8 months ago

    Data scientist here! What you have discovered is what’s known in data analytics as a semi-additive measure. Instead of summing the balance column, you would count it, and get a measure that showed how many transactions took place, but not a balance. Of course, there’s no reason to simply count the one column, a row count would suffice and return the same.