Forum Discussion

richard-powerbi's avatar
richard-powerbi
Icon for Post Patron rankPost Patron
6 years ago

Opposite of sum function

So there's the SUM function as a measure or explicit measure.   A, 10 A, 20 B, 15   Returns this:   A, 30 B, 15   Now let's say a faulty table already summed the values, but the amount of ...
Need Help
mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

Here is an expressiont that works with your sample data.  I called the table 'Reverse'.

 

Reverse Sum =
VAR __thisletter =
    MIN ( Reverse[Letter] )
VAR __count =
    CALCULATE (
        COUNTROWS ( Reverse ),
        ALL ( Reverse ),
        Reverse[Letter] = __thisletter
    )
VAR __thisaverage =
    AVERAGE ( Reverse[Number] )
RETURN
    DIVIDE ( __thisaverage, __count )

 

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat