Forum Discussion

Morgana_2022's avatar
Morgana_2022
Helper I
4 years ago
Solved

Dax formula problem

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...
DAX
DAX Calculation
  • johnt75's avatar
    johnt75
    4 years ago

    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" )
tamerj1's avatar
tamerj1
Community Champion
4 years ago

@H Morgana_2022 

please try

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