Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Divide entire column by a fixed value (inside the same column)

Hi everyone and apologize for my language, isnt mothertongue.

 

I have the following problem:

All I want is divide all the values by the "01 - INGRESOS" value to get the %.

 

EPIGRAFE_N1 and Imp_real are in the same table in the data model.

 

Thank you.

Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    Maybe something like this:

     

    aux = 
  VAR __01_INGRESOS = 
    MAXX(
      FILTER(
        ALL('Table'),
        [EPIGRAFE_N1] = "01 - INGRESOS"
      ),
      [Imp_real]
    )
RETURN
  DIVIDE(
    [Imp_real],
    __01_INGRESOS,
    0
  )

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Maybe something like this:

     

    aux = 
  VAR __01_INGRESOS = 
    MAXX(
      FILTER(
        ALL('Table'),
        [EPIGRAFE_N1] = "01 - INGRESOS"
      ),
      [Imp_real]
    )
RETURN
  DIVIDE(
    [Imp_real],
    __01_INGRESOS,
    0
  )
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Output =

    VAR ValueEpigrafe = 
    Sum(
           [Imp_real
    )

    VAR ValueEpigrafeIngresos =
    SUMX(
             FILTER(
                         All(Table),
                        Table[Epigrafe_N1] = "01 - Ingresos"
                      ),
             Imp_real
    )
    RETURN
    DIVIDE(ValueEpigrafe, ValueEpigrafeIngresos)