topic How to Count value in a table with measure. in DAX Commands and Tips

How to Count value in a table with measure.

Nestor_Moreno — Wed, 17 Jul 2019 12:56:54 GMT

Hi im new in DAX and have the next situation,

I have a table with 5 columns:

Nombre_Establecimiento
Ventas Periodo Anterior =
CALCULATE([Ventas_Periodo_Seleccionado];SAMEPERIODLASTYEAR('Calendar'[Date]))
Ventas Periodo Seleccionado =
CALCULATE(SUM(Empresario_Indicadores_Cuantita[Ventas]))
%_Crecimiento_Ventas =
(([Ventas_Periodo_Seleccionado]-[Ventas_Periodo_Anterior])/[Ventas_Periodo_Anterior])
Incremento_Ventas =
IF([%_Crecimiento_Ventas]>0;"SI";"NO")

The last 4 columns are measures. This measures are showing sales of each business of this year and the last year. With this information im calculating the % of increase in sales (%_Crecimiento_Ventas). In the last column i put a conditional measure that evaluate if the % is greates than 0 then show "SI" if not show "NO"

I need to count on the number of business that increased sales, (it mean Incremento_Ventas = SI), and show this value in a card visualization. for example in this table i need to show 4 business that increase sales.

Someone can help me with this trouble?

Thanks for your help

Re: How to Count value in a table with measure.

Anonymous — Wed, 17 Jul 2019 21:14:06 GMT

-- First, you should use DIVIDE instead of /

%_Crecimiento_Ventas = 
var __Ventas_Periodo_Seleccionado = [Ventas_Periodo_Seleccionado]
var __Ventas_Periodo_Anterior = [Ventas_Periodo_Anterior]
return
	divide(
		__Ventas_Periodo_Seleccionado - __Ventas_Periodo_Anterior,
		__Ventas_Periodo_Anterior
	)

-- And this is (most likely) what you need:

[# Businesses With SI] =
var __businesses = VALUES( Establecimientos[Nombre_Establecimiento] )
var __businessesWithSI =
	filter(
		__businesses,
		[Incremento_Ventas] = "SI"
	)
var __countOfbusinessesWithSI =
	countrows( __businessesWithSI )
return
	__countOfbusinessesWithSI

Best

Darek

Re: How to Count value in a table with measure.

Nestor_Moreno — Thu, 18 Jul 2019 12:57:16 GMT

Thanks Darlove.

It worked perfect!!!

Regards