英文:
Measure for sumproduct with a many to one relationship
问题
Table 1:
Table 2:
我需要一个度量，将执行SUM（每个Value2 * 相应的Value1）
我尝试了以下方法，但它不起作用 - 我认为是因为表的行数不同。
度量 = SUMX(Table2, Table2[Value2] * Table1[Value1])
英文:
Table 1:
Table 2:
I need a measure that will do SUM( every Value2* corresponding Value1)
I have tried the following but it does not work - I assume due to the tables being different number of rows.
Measure = SUMX(Table2, Table2[Value2] * Table1[Value1])
答案1
得分: 1
使用这个度量值来获得以下结果：
英文:
Assuming you have a relationship like this
use this measure
Measure =
SUMX(
Table2,
Table2[Value2] * RELATED(Table1[Value1])
)
to get this result:
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论