Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Help with Related( )

Hi,   I am trying to use the formula Related( ) with the next formula:   Horas Unidad = CALCULATE(SUM(Zon1[Horas Unidad]);FILTER(Zon1;Zon1[Unidad de Bombeo Indisponible]=RELATED(SBH_1[Unidad])))...
Need Help
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
6 years ago

hey DataChant  az38 

Every row has his respective "Unidad de bombeo indisponible" and "Horas unidad"(these are hours). And sometimes the "Unidad de bombeo indisponible" can repeat  in a different row with a different value of "Horas unidad". (This is in the "Zon1" table)

 

What I want is a calulated column in "SBH_1" table with the sum of "Horas unidad" from each "Unidad de bombeo indisponible".

The "unidad" column from SBH_1 has the same values of "Unidad de bombeo indisponible" with some repeated values I need.

So I create:

Horas Unidad = CALCULATE(SUM(Zon1[Horas Unidad]);FILTER(Zon1;Zon1[Unidad de Bombeo Indisponible]=RELATED(SBH_1[Unidad])))

 The tables has a many to many relationship because I relate the tables with "unidad" and  "Unidad de bombeo indisponible" and none of these has unique values.

 

Thanks

az38's avatar
az38
Community Champion
6 years ago

Anonymous 

didnt you try to add into SBH_1 table a super-simple measure?

Measure = calculate(SUM(Zon1[Horas Unidad]))

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hey,

     

    No, because in the "Unidad" column are some repeated values than I related, and I need to sum other values too.

    • az38's avatar
      az38
      Community Champion
      6 years ago

      Anonymous 

      what column do you use as a key for relationships?