Find the measure to calculate exact value for each Province

[Anonymous]

Hi All,

I have data like below. I use the measure :

VLTH Accumulated Launched Units =

    CALCULATE(

        TOTALQTD(SUM(VLTH[Total_Launched_Units]), 'Calendar'[DATE]),

        Project[Sector] = "VLTH"

    )

 VLTH Launched Units Last  =
SUMX (
VALUES ( Project[City] ),
CALCULATE (
LASTNONBLANKVALUE ( 'Calendar'[DATE], VLTH[VLTH Accumulated Launched Units])
)
)
The data show :

I want to find the measure to calculate the Lauched Unit Last for Provinces which have a beach ( Example : Khanh Hoa Province, Quang Ninh Province ) base on the measure VLTH Launched Units Last Value .

Launched Units Last Coastal =CALCULATE(VLTH[VLTH Launched Units Last], Project[City] IN {"Quang Ninh Province","Khanh Hoa Province"})

But the data show:

I know it wrong but can't fix it . Please help me how to seperate the result of Quang Ninh Province and Khanh Hoa Province  in the data .

[johnt75 · Accepted solution]

Try

Launched Units Last Coastal =
CALCULATE (
    VLTH[VLTH Launched Units Last],
    KEEPFILTERS ( Project[City] IN { "Quang Ninh Province", "Khanh Hoa Province" } )
)

[johnt75 · Accepted solution]

Try

Launched Units Last Coastal =
CALCULATE (
    VLTH[VLTH Launched Units Last],
    KEEPFILTERS ( Project[City] IN { "Quang Ninh Province", "Khanh Hoa Province" } )
)

[Anonymous · Accepted solution]

Thank you johnt75 so much !😀