How to create SEGMENT_C field at SALES Table ?

[Paulyeo11]

Hi All

I have try below , it cannot work :-

SEGMENT_C = SUM('Z_SEGMENT'[SEGMENT_C])

[v-yingjl · Accepted solution]

Hi @Paulyeo11 ,

In power bi, different columns from different tables could not be moved directly if there are no related columns in these tables as @ amitchandak mentioned.

If these tables have related columns(relationship is optional), you can add a new column in another table.

For example, Here is table 1 and table2 which have related fields [ID]:
table1table2

Now I want to create a new [Sales] column in table 2 which calculates the total sales for each ID, create a calculated column like this:

Column = 
CALCULATE (
    SUM ( 'Table 1'[Sales] ),
    FILTER ( ALL ( 'Table 1' ), 'Table 1'[ID] = EARLIER ( 'Table 2'[ID] ) )
)

 

Attached the sample file in the below, hopes to help you.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Paulyeo11]

Hi Ying

Thank very much for your sharing. I can understand what you try to do. 

Paul

[amitchandak]

@Paulyeo11 , a column can not be moved. If they have some relation value can be copied: https://www.youtube.com/watch?v=czNHt7UXIe8

measure can move - refer a prt of this video -https://www.youtube.com/watch?v=b9oDIL8nbu0