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.
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
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
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 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |