How to do it...

To implement this recipe, perform the following steps:

1. Create the following measures:

My Calculation = 
    VAR __Calculation = 
        CALCULATE(
            SUM('R07_Table'[Value]),
            'R07_Table'[Color] <> "Blue"
        )
RETURN
    __Calculation

2. Create the following table:

R07_Debug = 
    VAR __Table = 
        FILTER(
            'R07_Table',
            'R07_Table'[Color] <> "Blue"
        )
    VAR __Calculation = 
        CALCULATE(
            SUM('R07_Table'[Value]),
            'R07_Table'[Color] <> "Blue"
        )
RETURN
    __Table

3. On a Report page, create a Card visualization and place the My Calculation measure in the Fields area of the visualization.