Forum Discussion
Problem: Summing Values from another Table, only using Mesures.
Hi guys, I want to change my connections in power bi from import to direct query, for that I need to find a solution to this problem that only envolve mesures and not adding columns to my data. ...
FarmaVip Perhaps I am missing something. Why is it not just SUM('Table 2'[Margem]) ? That would be the sum of all Margem in Table 2. If you put NOM from table 1 in a visualization along with that measure then as long as there is a relationship between the two you will get the sum of the Margem for each product.
Because "Table 2'[Margem] is a custom column that I create that take the values from Table 1[Margem] using the Related function. I want to do this withou creating any custom column.
I want to use Direct Query to connect my data. That way I can't creat or modify any data inside powerbi (and creat new columns). So I have to use mesures to solve this problem.
