Forum Discussion

wmoura12's avatar
wmoura12
Regular Visitor
8 years ago
Solved

How can I divide a column by a fixed value

How can I divide a column by a fixed value   I´m in trouble with an issue that seems to be easy to solve, but I can´t do it. I have a Matrix and i need to create a measure or a column dividing MOV ...
  • wmoura12's avatar
    wmoura12
    8 years ago

    Maybe you can change the table

    Medida = Calculate([MOV YTD];ALL(dEBITDA);Filter(dEBITDA;dEBITDA[CONTA_EBITDA]="RECEITA LIQUIDA");dRazao)

     

    The number has changed but it is wrong.

     

    After several attempts, I succeeded

     

    %Vert RLiq =

    VAR DEN_01 = CALCULATE([RL YTD];ALLSELECTED(dRazao); FILTERS(dColigada[Empresa_Simples]))
    VAR NUM_01 = [MOV YTD]

    RETURN
    DIVIDE(NUM_01;DEN_01;0)

     

Floriankx's avatar
Floriankx
Solution Sage
8 years ago

It's tricky.

 

I see you have a separate table for your measures. Maybe this causes the problem.

 

Next try:

Medida = Calculate([MOV YTD];ALL(dEBITDA);Filter(dEBITDA;dEBITDA[CONTA_EBITDA]="RECEITA LIQUIDA");dEBITDA)

 

You can add a table as Filter in Calculate so the measure is calculated as it would be if you had calculated it in this table.

(I don't know if this is correct in grammar, but I hope it's understandable)

wmoura12's avatar
wmoura12
Regular Visitor
8 years ago

It's tricky.

I see you have a separate table for your measures. Maybe this causes the problem.

 

Yes..5 days trying and failing! I did it  according the good practices to organize it better, but if it is a issue i can join it all in dRazao.

 

Next try:

Medida = Calculate([MOV YTD];ALL(dEBITDA);Filter(dEBITDA;dEBITDA[CONTA_EBITDA]="RECEITA LIQUIDA");dEBITDA)

 

Same Result.

 

You can add a table as Filter in Calculate so the measure is calculated as it would be if you had calculated it in this table.

 

 I did not understand

 

tks

 

Wallace

  • Floriankx's avatar
    Floriankx
    Solution Sage
    8 years ago

    I understand why you are on it for such a long time.

     

    Maybe you can change the table

    Medida = Calculate([MOV YTD];ALL(dEBITDA);Filter(dEBITDA;dEBITDA[CONTA_EBITDA]="RECEITA LIQUIDA");dRazao)

    • wmoura12's avatar
      wmoura12
      Regular Visitor
      8 years ago

      Maybe you can change the table

      Medida = Calculate([MOV YTD];ALL(dEBITDA);Filter(dEBITDA;dEBITDA[CONTA_EBITDA]="RECEITA LIQUIDA");dRazao)

       

      The number has changed but it is wrong.

       

      After several attempts, I succeeded

       

      %Vert RLiq =

      VAR DEN_01 = CALCULATE([RL YTD];ALLSELECTED(dRazao); FILTERS(dColigada[Empresa_Simples]))
      VAR NUM_01 = [MOV YTD]

      RETURN
      DIVIDE(NUM_01;DEN_01;0)