Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi im new in DAX and have the next situation,
I have a table with 5 columns:
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
Solved! Go to 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
-- 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
Thanks Darlove.
It worked perfect!!!
Regards
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
27 | |
13 | |
11 | |
9 | |
6 |