Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Create a Calculated Column/measure from Different Tables

Hi Everyone,   The relationship between 2 tables is 1: many. How can I get the table I would like? Thank you in advance!  
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thanks a lot!

I used this as a measure before, so it doesn't work.

 

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's avatar
Zubair_Muhammad
Community Champion
8 years ago

Hi Anonymous

 

Try this calculated column

 

=
IF (
    TableA[GROUP] <> "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" ) )
        )
    )
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Thanks for your reply!

     

    I am sorry for confusing explain.

     

    Actually, the data I provided is an example and left table is the table I want to display on the report.

     

    So there is no "Total" in any coolumns and more than 2 total group actually.

     

    Could you please give me other suggestions?