Forum Discussion

andre1981's avatar
andre1981
New Member
6 years ago
Solved

Compare value by highest selected month

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) ) Valor...
Need Help
  • andre1981's avatar
    andre1981
    6 years ago

    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

andre1981's avatar
andre1981
New Member
6 years ago

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