Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Problems with SUMX

Hi, i am trying to accumulate the results of the following measure: ind_rotacion =    VAR rota_colab =       SUM(Sheet1[ROTACION])    VAR totalcolaborador=       COUNT(Sheet1[Contrato]) RETUR...
Need Help
Show and Tell
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    Refer the formula.

    Measure = SUMX(FILTER(ALLSELECTED(sheet1[Mes]),sheet1[Mes]<=MAX(sheet1[Mes])),[ind_rotacion])

     

    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

 

Refer the formula.

Measure = SUMX(FILTER(ALLSELECTED(sheet1[Mes]),sheet1[Mes]<=MAX(sheet1[Mes])),[ind_rotacion])

 

Best Regards,

Jay

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thank you so much Jay, i've been looking for this answer quite some time now. it worked!! Would you please explain me the difference between filter by Sheet1 and filter by Sheet1[month]. It made a difference in the result