Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Sum except one cateogry

 I want sum a table but without one category, like a filter, but this expression do the opposite what i want. I think the answer is not hard but i can't find, the most close i don't understand.    ...
Need Help
Tutorial Requests
  • jdbuchanan71's avatar
    jdbuchanan71
    3 years ago

    Anonymous 

    Try it like this.

    Filtered Value = 
IF ( 
    ISINSCOPE ( YourTable[Category] ), CALCULATE ( SUM ( YourTable[Value] ) ),
    CALCULATE ( SUM ( YourTable[Value] ), NOT YourTable[Category] IN {"Data 3"} )
)

     

jdbuchanan71's avatar
jdbuchanan71
Super User
3 years ago

Anonymous 

Try it like this.

Filtered Value = 
IF ( 
    ISINSCOPE ( YourTable[Category] ), CALCULATE ( SUM ( YourTable[Value] ) ),
    CALCULATE ( SUM ( YourTable[Value] ), NOT YourTable[Category] IN {"Data 3"} )
)