Calculate total sum by category and add extra value to each category.

[Anonymous]

Hi, 

this time i would like to ask you to support me in following case: 

inputa table 

Expected table -  works well

Measure to improve 

Result of measure 

How to update syntax in measure to have 
calculated total sum by category and have posibilities to add extra value to each category.

Thank you in advance for your reply. 

[AlexisOlson · Accepted solution]

My first thought was that you just need to move "+ 100" inside SUMX but that would give 407, not 307.

You need to iterate at the level you want to sum at (Category).

CategorySum =
SUMX (
    VALUES ( 'Table'[Category] ),
    CALCULATE ( SUM ( 'Table'[Value] ) + 100 )
)

[smpa01]

@Anonymous  try this

Measure =
SUMX (
    ADDCOLUMNS (
        VALUES ( 'Table'[Category] ),
        "sum", CALCULATE ( SUM ( 'Table'[Value] ) ) + 100
    ),
    [sum]
)