Dax formula problem

[Morgana_2022]

Hello,
I have a table and a single value next to it.

I would like to show as single value not the total of vend_lord_cy but the vend_lor_cy for Mese Corrente.
What is the correct dax formula?

Vend_Lord_cy_current_month = CALCULATE (SUM ('table' [vend_lord_cy] ...?

Thanks to who helps me!

[tamerj1]

@H @Morgana_2022 

please try

Vend_Lord_cy_current_month Card =
CALCULATE (
    SUM ( 'table'[vend_lord_cy] ),
    'table'[colonna_kpi] = "Messe Corrente"
)

[johnt75 · Accepted solution]

You could just put a filter on the card visual but if you want to do it as a measure you could use

Vend_Lord_cy_current_month = CALCULATE (SUM ('table' [vend_lord_cy]), 'Table'[colonna_kpi] = "Mese Corrente" )