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?

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

Thanks to who helps me!

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" )

2 Replies

  • 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" )
  • 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"
)