Forum Discussion

Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
9 years ago
Solved

ALL Function - Mystery?

Hello ALL, I'm encountering a problem/issue with this simple formula. The problem must be with my data but I can't seem to figure out where? So here's the Measure => County Total County Total = C...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
9 years ago

Isn't the County Total measure suppose to be having sum function or it is just a typo

 

County Total = CALCULATE ( SUM([Total Net]), ALL(Payments[Subcategory], Payments[Category]) )

 

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    9 years ago

    Also can you try  which is very less likely the issue but would be good to try.

     

    County Total = CALCULATE ( SUM([Total Net]), ALL(Payments))

     

    • Sean's avatar
      Sean
      Icon for Community Champion rankCommunity Champion
      9 years ago

      Hey thanks for replying.

      1) Total Net is a already a Measure = SUM ( Payments[Net] ) I had listed it under the County Total Measure above

      2) ALL(Payments) gives the Overall Total Net for all Counties

      • parry2k's avatar
        parry2k
        Icon for Super User rankSuper User
        9 years ago

        You are right, you need total by county regardless what category/sub category it is. Not sure why this will work on sample data and not on real data.

         

        I was referring to your "County Total" which missing SUM function, I'm sure that was typo.