How to Count value in a table with measure.

[Nestor_Moreno]

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

[Anonymous · Accepted solution]

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

[Nestor_Moreno]

Thanks Darlove.

It worked perfect!!!

Regards