Create a Calculated Column/measure from Different Tables

Question

Hi Everyone,&nbsp;The relationship between 2 tables is 1: many.How can I get the table I would like? Thank you in advance!&nbsp;

zubair_muhammad · Answer

hI Anonymous&nbsp;Use this calculated column in Table A&nbsp;G =
DIVIDE ( Table A[E], RELATED ( Table 2[F] ) )

anonymous · Answer

Thanks a lot!However,&nbsp;after I input "Related", I can't input the column name then. This may be caused by "one to many" relationship.Could you have any advices to solve this? Thanks!

zubair_muhammad · Answer

Hi Anonymous&nbsp;RELATED is used in Many-Side Table to pull information from ONE-SIDE. Its like a VLOOKUP&nbsp;It works fine when I used your sample data. See the image below&nbsp;&nbsp;&nbsp;

anonymous · Answer

Thanks a lot!I used this as a measure before, so it doesn't work.&nbsp;Now it works well.However, I meet a new problem now. Could you help me to solve this? I would like to get the column/measure filled in grey.Thank you in advance!

zubair_muhammad · Answer

Hi Anonymous&nbsp;Try this calculated column&nbsp;=
IF (
    TableA[GROUP] &lt;&gt; "Total",
    RELATED ( Table2[F] ),
    IF (
        TableA[TOTAL GROUP] = "One",
        CALCULATE (
            SUM ( Table2[F] ),
            FILTER ( ALL ( Table2 ), Table2[GROUP] = "A" || Table2[GROUP] = "B" )
        ),
        IF (
            TableA[TOTAL GROUP] = "Two",
            CALCULATE ( SUM ( Table2[F] ), FILTER ( ALL ( Table2 ), Table2[GROUP] = "C" ) )
        )
    )
)

Forum Discussion

Create a Calculated Column/measure from Different Tables

6 Replies

Related content

What is the difference between a measure and calculated column

Measure or Calculated Column

Performance difference between calculated column or measure?

Measure converted to Calculated column shows different result

Convert calculated column into measure