Forum Discussion

walkery's avatar
walkery
Helper I
8 years ago
Solved

Dividing Measure Calculation by Column from another table

Hi All,    I have 2 tables in my report, Table A has 3 columns: Month, Office, OfficeCommission and Table B has 3 columns: Month, Office, OfficeRevenue. What I'd like to do is to divide office comm...
Need Help
  • MFelix's avatar
    MFelix
    8 years ago

    Hi walkery,

     

    If you are using the Direct Query you cannot create new tables directly check the Using DirectQuery in PowerBI link that as the complete details and limitations.

     

    Regarding your second question there is a relationship between both dimension tables and the main tables, then I use the dimension tables on the visuals to create context.

     

    Regards,

    MFelix

walkery's avatar
walkery
Helper I
8 years ago

Hi MFelix thanks for the suggestion! This is probably a basic question, but how can I create a dimension table? Because I'm using a direct query I don't think that I can create a new table so not sure if that'll effect my ability to create a dimension table?

 

I also saw in your example that then you create a relationship from the main tables to the dimension tables. Is that correct? Still learning the basics of PowerBI so apologies if it's a really stupid question. 

MFelix's avatar
MFelix
Super User
8 years ago

Hi walkery,

 

If you are using the Direct Query you cannot create new tables directly check the Using DirectQuery in PowerBI link that as the complete details and limitations.

 

Regarding your second question there is a relationship between both dimension tables and the main tables, then I use the dimension tables on the visuals to create context.

 

Regards,

MFelix