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

[Anonymous]

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.

[Anonymous]

Output =

VAR ValueEpigrafe = 
Sum(
       [Imp_real
)

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

[Greg_Deckler · Accepted solution]

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
  )