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
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)