Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
Hola, Me surge una duda.
Tengo la siguiente tabla:
con las medidas:
Solved! Go to Solution.
Hi @Rac3rss ,
Are you referring to the fact that the maximum in LO1 should be 120,000, but the red label is on 110,000?
You need to change Max() to the Sum() function, otherwise the maximum data of the current grouping will be displayed, not the added data.
%Lo1 = CALCULATE(SUM(Principal[Amount]), FILTER(ALL(Principal), 'Principal'[Prov]=MAX('Principal'[Prov])&&Principal[Lo]="LO 1"))
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 @Rac3rss ,
Are you referring to the fact that the maximum in LO1 should be 120,000, but the red label is on 110,000?
You need to change Max() to the Sum() function, otherwise the maximum data of the current grouping will be displayed, not the added data.
%Lo1 = CALCULATE(SUM(Principal[Amount]), FILTER(ALL(Principal), 'Principal'[Prov]=MAX('Principal'[Prov])&&Principal[Lo]="LO 1"))
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 @Rac3rss ,
You can try the following dax:
MaxLotX =
IF(
[%LotX]=
MAXX(
ALLSELECTED('Table'),[%LotX]), "Orangered", "Blank"
)
The link to the file you posted shows that it has been deleted after clicking on it, and the DAX on it is written based on the sample data you gave.
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.
Lo puedes probar ahora??
He probado tu solución pero no funciona.
Gracias.
Aggregate Amounts by Prov
TotalAmountByProv = SUM('YourTableName'[Amount])
Use the measure in the visual. Then
Provide a sample dataset of the pbix file if possible. I will try to solve your problem.
Proud to be a Super User!
Como te puedo adjuntar el archivo .pbix??
Saludos.
from your browser go to file.io and upload the pbix there then paste the link here.
Proud to be a Super User!
Hola, Lo has podido revisar?
Gracias.
can you please upload the file again? it's been deleted
Proud to be a Super User!
Hi @Rac3rss
First, ensure that you have a column or measure that sums the amounts you are interested in. Let's call this column or measure TotalSum. Then review the first dax
%LotX = CALCULATE(SUM(Table[TotalSum]), FILTER(Table, Table[Column]="X"))
This formula will sum up the TotalSum column (or measure) for rows where [column]="X".
MaxLotX = IF([%LotX] = CALCULATE(MAXX(VALUES(Table[TotalSum]), [%LotX]), REMOVEFILTERS(Table)), "Orangered", "Blank")
Proud to be a Super User!
Hola, no me funciona. Quiza me he explicado mal.
Tengo la siguiente tabla matriz:
Prov | Importe |
A | 155.000 |
B | 200.000 |
C | 119.000 |
Ahora mismo me resalta los 155k ya que es el valor máximo de la tabla principal, pero necesito resaltar los 200k ya que es la suma de 3 valores de la columna. Es decir, en la tabla principal tengo lo siguiente:
Prov | Importe |
A | 155.000 |
B | 50.000 |
B | 50.000 |
B | 100.000 |
C | 119.000 |
Como ves, el importe más alto de la columna Importe es 155k pero el que tiene la suma de los importes más altos es el B con un total de 200k.
Como lo puedo solucionar para marcar los 200K en vez de los 155k?
Muchas gracias.
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
93 | |
88 | |
83 | |
76 | |
49 |
User | Count |
---|---|
145 | |
140 | |
109 | |
68 | |
55 |