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)

     

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
Icon for Solution Sage rankSolution 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)