RelatedTable Context

[armand453]

Hello, is it possible to change the context of evaluation of a relatedtable formula?

Origin formula : sumx(RELATEDTABLE(Mapping_Ventilation);Mapping_Ventilation[Taux BRANCH])

I'd like to do something like that :

sumx(RELATEDTABLE(ALL(Mapping_Ventilation));Mapping_Ventilation[Taux BRANCH])

[v-juanli-msft]

Hi @armand453

Do you create this formula in another table instead of Mapping_Ventilation?

Why not calculate the sum column in the Mapping_Ventilation table, then relate this column to this table by "RELATED" function?

Or, could you show what expected results after changing the formula so that we can analyze more sufficent?

Best Regards

Maggie

[Zubair_Muhammad]

@armand453

What if you use

sumx(ALL(Mapping_Ventilation);Mapping_Ventilation[Taux BRANCH])

or simply

sumx(Mapping_Ventilation;Mapping_Ventilation[Taux BRANCH])

[armand453]

Thanks for your answer but, the first solution doesnt work.

And the second doesnt fit beacause I have a second table whose name is "DATA" that is related to "Mapping_Ventilation" and I want to change the context of this table before the evaluation of Relatedtable("Mapping_Ventilation"), I don't know if it is possible...