Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi
I need to compare the monthly value with the value of the highest month selected, I'm using the measurements:
MaiorMesSelecionado = CALCULATE( MAX(VENDAS[MES]), ALLSELECTED(VENDAS) )
ValorMaiorMesSelecionado = CALCULATE(SUM(VENDAS[VALOR]),FILTER(VENDAS,VENDAS[MES] = [MaiorMesSelecionado]))
If I set the month 11, everything works
ValorMaiorMesSelecionado = CALCULATE(SUM(VENDAS[VALOR]), FILTER(VENDAS,VENDAS[MES] = 11))
, but when I use the measure of the biggest month, nothing works
this is my report
DATA
Need help
Solved! Go to Solution.
I found the error
Previous measure (wrong): MaiorMes = CALCULATE(MAX(producao[MESREFERENCIA]);ALLSELECTED(producao[MESREFERENCIA]))
Correct Measure: MaiorMes = CALCULATE(MAX(producao[MESREFERENCIA]);ALLSELECTED(producao))
in the function ALLSELECTED, I added the table field, and I should have just added the table
I found the error
Previous measure (wrong): MaiorMes = CALCULATE(MAX(producao[MESREFERENCIA]);ALLSELECTED(producao[MESREFERENCIA]))
Correct Measure: MaiorMes = CALCULATE(MAX(producao[MESREFERENCIA]);ALLSELECTED(producao))
in the function ALLSELECTED, I added the table field, and I should have just added the table
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 36 | |
| 33 | |
| 30 | |
| 28 |
| User | Count |
|---|---|
| 128 | |
| 88 | |
| 79 | |
| 67 | |
| 62 |