DAX apply measure filter on the calculation

[SniperPro86]

Hello
On the Contoso model I have a simple measure that calculate the amount of red product:

Red Sales = CALCULATE(
    [Amount],
    'Product'[Color] = "Red"
)

I want to create a measure that shows the Amount where the [Red Sales] is not blank without manually filtering the visual.
Below the expected result with filter on the visual :

[tamerj1]

@Greg_Deckler this is where CALCULATE fails to do its job.

[tamerj1]

Hi @SniperPro86 

please try

Red Sales =
CALCULATE ( [Amount], KEEPFILTERS ( 'Product'[Color] = "Red" ) )

[SniperPro86]

Hi @tamerj1 
I don't want to calculate just the Amount of red product.
I want all the sales amount of the current context but just show the rows where there is a sales of a red product.
For exemple, I want all sales amount of customers who purchased at least one red product.
or all sales amount by years but just show the years where at least one sales of a red product happened.
I don't know if the requirement is clear.

[tamerj1 · Accepted solution]

@SniperPro86 
Please try

MeasureTest3 =
SUMX (
    FILTER (
        VALUES ( Customer[Name] ),
        [Red Sales] <> BLANK ()
    ),
    [Amount]
)

Or 

MeasureTest4 =
SUMX (
    SUMMARIZE (
        FILTER (
            Sales,
            RELATED ( 'Product'[Color] ) = "Red"
        ),
        Customer[Name]
    ),
    [Amount]
)

[SniperPro86]

@tamerj1 
Thank you this is the elegant way I was searching for.

[FreemanZ]

hi @SniperPro86 

try like:

Measure =

SUMX(

    CALCULATETABLE(

        VALUES(PRODUCT[Name]),

        FILTER(

            PRODUCT,

            PRODUCT[Color]="Red"

        )

     ),

    [Amount]

)

[SniperPro86]

Hello @FreemanZ 
This is not working.
I wrote the measure below:

Measure Test 2 = 
var CustomerR = FILTER(VALUES(Customer[Name]), [Red Sales] <> 0)
Return
CALCULATE(
    [Amount],
    Customer[Name] in CustomerR
)

It is working fine when I do analyse by customer Name but give a wrong result when I analyse by date for exemple.