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 its me again 🙂
I did the following formula to rank some data with two (2) filters:
Solved! Go to Solution.
Hi @pfinanciero ,
Try to create 2 measures:
Measure_ranking = AVERAGEX(VALUES('Table'[Indicador]),AVERAGE('Table'[rank]))
Measure_valor = AVERAGEX(VALUES('Table'[Indicador]),AVERAGE('Table'[Valor]))
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @pfinanciero ,
Try to create 2 measures:
Measure_ranking = AVERAGEX(VALUES('Table'[Indicador]),AVERAGE('Table'[rank]))
Measure_valor = AVERAGEX(VALUES('Table'[Indicador]),AVERAGE('Table'[Valor]))
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@pfinanciero provide sample data and expected output
Hi @smpa01 ,
I have the following data chart:
In the firt column "Razón social" are the names of the diferents companies, the secod column shows the type of the rate or indicator (if its an asset or a sale) for this example, the third column are the values and the last one is the year.
with this information I build the following table:
As you can see I insert an slicer with "Razón social" because the idea of the chart is to shows the values and raking of each company selected.
I need to calculate in the total row of the column Ranking the average of the results of that year, for example:
Fecha | 2018 | 2019 | 2020 | Total | ||||
Indicador | Valor | Ranking | Valor | Ranking | Valor | Ranking | Valor | Ranking |
Activos | 133.802 | 71 | 131.801 | 90 | 145.185 | 81 | 410.788 | 81 |
Ventas | 136.124 | 69 | 124.006 | 101 | 124.682 | 94 | 384.992 | 88 |
Total | BLANK | 70 | BLANK | 96 | BLANK | 88 | BLANK | 85 |
The basic pattern for this will look like:
AVERAGEX (
SUMMARIZE ( Prueba, Prueba[Fecha], Prueba[Indicador] ),
[Ranking measure]
)
Note that if there is only one Fecha and Indicador in the filter context, you're only averaging over one value, so the result is the same as [Ranking measure].
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
12 | |
10 | |
10 | |
6 |