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] )
    )
)

ChrisMendoza's avatar
ChrisMendoza
Resident Rockstar
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] )
    )
)