Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Buenos días,
Tengo calculada una medida rápida que introduzco como elemento en el numerador de una nueva medida ràpida, a esta nueva medida rápida le aplico un filtro, pero no funciona. No ofrece el resultado que debería dar.
Gracias
Solved! Go to Solution.
Hi @gerenciajanda ,
You can use Measure and selectvalue() to do it.
I created some data:
Here are the steps you can follow:
1. Create measure.
all_amount = SUMX(ALL('Table'),'Table'[Amount])
group_amount =
var _select=SELECTEDVALUE('Table'[Month])
return
SUMX(FILTER(ALLSELECTED('Table'),'Table'[Month]=_select),[Amount])
divide =
DIVIDE([group_amount],[all_amount])
2. Used [Month] as a slicer.
3. Result:
When the slicer selects, the measure changes accordingly:
The slicer is 10:
The slicer is 11:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @gerenciajanda ,
You can use Measure and selectvalue() to do it.
I created some data:
Here are the steps you can follow:
1. Create measure.
all_amount = SUMX(ALL('Table'),'Table'[Amount])
group_amount =
var _select=SELECTEDVALUE('Table'[Month])
return
SUMX(FILTER(ALLSELECTED('Table'),'Table'[Month]=_select),[Amount])
divide =
DIVIDE([group_amount],[all_amount])
2. Used [Month] as a slicer.
3. Result:
When the slicer selects, the measure changes accordingly:
The slicer is 10:
The slicer is 11:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Primero he creado dos medidas rápidas y luego he creado una tercera medida rápida, que es una división de las dos medidas rápidas anteriores. Sobre estas luego he aplicado un filtro que no integro en la medida rápida, sinoi que utiliazo la opción del panel de filtros. el resultado no lo da bien, no lo calcula
Gracias
@gerenciajanda , you can create a new measure and add filter
example
Calcullate([Quick Meausre 1], filter(Table, Table[Col]="ABC" ))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |