Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Bug when using Calculate with variables

Hey, everyone.   I'm having a problem with Calculate and Variables.   This is the data I generated for the Proof of Concept       I'm trying to obtain the sum of amount in each ca...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • ChrisMendoza's avatar
    ChrisMendoza
    7 years ago

    Anonymous -

    I might have chosen a different method that you may find useful based off of what you've shown:

    Measure =
IF (
    ISFILTERED ( Planiha1[Client] ),
    SUM ( Planiha1[Amount] ),
    CALCULATE (
        SUM ( Planiha1[Amount] ),
        ALLEXCEPT ( Planiha1, Planiha1[Category] )
    )
)

mattbrice's avatar
mattbrice
Solution Sage
7 years ago

The problem is that variables are evaluated in the context they are initialized, not when they are used.  In your example "amount" was already computed before it was used in your calculate function, so it returned the total of the "'Planilha1 (2)'[Amount]" column.   ok?