Forum Discussion
Help with Related( )
Hi Anonymous
Can you provide more details on the format of the two tables and what is the current relationship between the two tables? Any reason you use many-to-many relationship here? (This is not recommended).
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
Anonymous
didnt you try to add into SBH_1 table a super-simple measure?
Measure = calculate(SUM(Zon1[Horas Unidad]))Hey,
No, because in the "Unidad" column are some repeated values than I related, and I need to sum other values too.
Anonymous
what column do you use as a key for relationships?
