Forum Discussion

PowerBINoob24's avatar
PowerBINoob24
Resolver I
3 years ago

Quick question about creating tables

I've got a Power BI dashboard that has four tables.  One table has a unique value (email address) that i use as the key to create a relationship with the othe three tables.

 

I'm trying to create a table for metrics, that will include columns from each of the tables, but only allows me to data from two tables.  Is there a limit on the number of tables that can be used when creating another table using summarize?

Need Help

3 Replies

  • FreemanZ's avatar
    FreemanZ
    Super User
    3 years ago

    there shall be no limit. But the first table argument shall be from the many side of the relationships of other column arguments, like this:

    SUMMARIZE(

       FactTable, Dim1[Col1], Dim2[Col2]...

    )

     

    i tried and it worked like this:

     

    • PowerBINoob24's avatar
      PowerBINoob24
      Resolver I
      3 years ago

      So I was actully mistaken.  I can bring data in from 3 of the 4 tables.  I tried your suggestion, but still can only bring data in from 3 of the 4 tables.

      • FreemanZ's avatar
        FreemanZ
        Super User
        3 years ago

        can you share the code and result with a screenshot?