Forum Discussion
calculating two measures
Hi, I have a measure e.g. measuresTable[Pool_Total] which calculates sales for a country. the result is something like 1743.49 here's measure: Pool_Total = CALCULATE ( SUMX ( FILTE...
Multiplication should ideally be sum(A*B)
From multiple tables, it needs a row context, preferably a common dimension
sum(summarize(Dimension,Dimension[Name],"_1",[Pool_Total],"_2", [Pct]),[_1]*[_2])Refer: the importance of row context : https://community.powerbi.com/t5/Community-Blog/Decoding-Direct-Query-in-Power-BI-Part-2-Date-Difference-Across/ba-p/934397#M451
if you need more help make me @
Appreciate your Kudos.