topic Dax formula problem in DAX Commands and Tips

Dax formula problem

Morgana_2022 — Tue, 26 Jul 2022 08:41:28 GMT

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!

Re: Dax formula problem

johnt75 — Tue, 26 Jul 2022 10:35:19 GMT

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

Re: Dax formula problem

tamerj1 — Tue, 26 Jul 2022 10:38:56 GMT

@H Morgana_2022

please try

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