SUM VALUES THAT I HAVE IN A DIMENSION TABLE UNDER THE CRITERIA OF A FACT TABLE

[chrisu793]

Hello. I have a dimension table called ratio that has two fields:
1) Type of Operation
2) Ratios
I show below.

And I have a fact table that contains a column "Tipo de Operación". They are related by the Type of Operation.

The point is that I need to take the values ​​that appear in the Ratio dimension field (FEE Contract) and multiply each value by its corresponding "Tipo de Operación" in the fact table using a measure.

I have done the job using the related function, but I wanted to know if there is another more practical and lightweight way to do it. Thank you.

[MFelix · Accepted solution]

Hi @chrisu793 ,

For this you need to do a measure like the following:

Total by Ratio= SUMX(FACTTABLE, FACTTABLE[Value] * RELATED(RATIO[FEE_Contrato]))