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.
Buen día,
Tengo una tabla calculada con summarize de la siguiente forma:
Solved! Go to Solution.
Hi @pfinanciero ,
What you seem to have created is a calculated column, the value of a calculated column is computed during data refresh and uses the current row as a context. It does not depend on user interaction in the report. That's why you switch different years for the slicer, but the value of [Ranking ventas] remains the same...
You can create a measure just as the ones in following links, unlike the calculated column, the measure operates on aggregations of data defined by the current context, which depends on the filter applied in the report – such as slicer, rows, and columns selection in a pivot table, or axis and filters applied to a chart.
Static vs Dynamic ranking in Power BI
DYNAMIC RANKX BY SLICER SELECTION IN POWER BI
Please find more details in the following links about the difference of calculated column vs measure.
Calculated Columns and Measures in DAX
Calculated Columns vs Measures
Best Regards
@pfinanciero , As the ranking happening at the table level, I doubt addition of column from same table is going to make a difference
maybe you want to rank for
RANKX(ALLSELECTED('Tabla ranking'[Business name]),'Tabla ranking'[Ventas],,DESC,Dense)
For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
La base de datos que tengo es así:
Las medidas de ingresos, activos, ebitda y patrimonio son calculadas a partir de la columna saldo ($m), teniendo en cuenta el número de cuenta que está en la columna cuenta puc.
A partir de esa información creé la siguiente tabla calculada:
En esta tabla calculada inserté una columna calculada con el nombre de "Ranking ventas":
El ranking de ventas no tiene en cuenta el filtro del año, existe alguna solución para esto? Como podras observar ya utilicé el ALLSELECTED, lo estoy utilizando mal?
Hi @pfinanciero ,
What you seem to have created is a calculated column, the value of a calculated column is computed during data refresh and uses the current row as a context. It does not depend on user interaction in the report. That's why you switch different years for the slicer, but the value of [Ranking ventas] remains the same...
You can create a measure just as the ones in following links, unlike the calculated column, the measure operates on aggregations of data defined by the current context, which depends on the filter applied in the report – such as slicer, rows, and columns selection in a pivot table, or axis and filters applied to a chart.
Static vs Dynamic ranking in Power BI
DYNAMIC RANKX BY SLICER SELECTION IN POWER BI
Please find more details in the following links about the difference of calculated column vs measure.
Calculated Columns and Measures in DAX
Calculated Columns vs Measures
Best Regards
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 |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |