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" )
johnt75's avatar
johnt75
Super User
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" )