Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
DavidSSAA
Frequent Visitor

Make calculation of two columns form different tables

Hi,

I have this view

 Capture.JPG

 

I want to make calculation Con/Leads

Con and Leads are from different tables, so to add cal column in one table is not working.

Is it possible to add calcualtion to this can of view?

Thanks!

 

1 ACCEPTED SOLUTION

Hi @DavidSSAA,

 

According to your description above, you can just use the formula below to create a new measure(no matter in what table) as austinsense suggested above in this case. Both Con and Leads columns should be recognized and it should work.

Con/Leads = DIVIDE ( SUM ( Table1[Con] ), SUM ( Table2[Leads] ) )

If you still have any issue with creating the measure, could you post all your table structures and the measures you have tried using? It is better to share a sample pbix file. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.Smiley Happy

 

Regards

View solution in original post

9 REPLIES 9
austinsense
Impactful Individual
Impactful Individual

Does this work?

 

Con/Leads = DIVIDE( SUM(Con), SUM(Leads) )
Austin is VP Operations at PowerPivotPro and a professional self-service enthusiast 🙂

Nope ..

Where I should put this calcualtion ?

if i put it in one table he can recognize the other field

Ok so this a BIG difference in PowerBI/PowerPivot vs regular Excel - we don't add a column to the dataset.  That's called a calculated column.  We want to create a measure.  A measure doesn't exist in this table or that table - it exists when we try to use it in a report and it can access any table in your model.

 

I'm pretty excited for you to discover this concept - it's going to change your life. 🙂

Austin is VP Operations at PowerPivotPro and a professional self-service enthusiast 🙂

Sorry for the numb question

where in the power bi i make this calulation?

because when i press the new measure button i get a new column in my table

Hi @DavidSSAA,

 

To create a measure in Power BI Desktop, you can right click, or click the down arrow on the table in the field list, and then click New Measure.

 

You can also create a new measure by clicking on the New Measure button in the ribbon on Power BI Desktop’s Home tab.

 

For more details about Measures and how to create it in Power BI, you can refer to the following articles.Smiley Happy

Measures in Power BI Desktop

Create your own measures in Power BI Desktop

 

Regards

@v-ljerr-msft

Thanks for the reply.

I already know how to make a cal in PBI.

Here the situation is different, Date, Leads and Con are from different tables that have key date.

So if I add Cal it need to be in specific table (not in chart for exmaple) if i make the measure in date table PBI is not familer with Con and Leads. If I make the measure in Leads PBI is not familer with Con and so on.

 

If i could make the measure per chart it will solve my problem - is it possible?

Or if i could make a new table that joins all the other table it will work as well I believe.

Is one of the option possible?

 

Thanks for any help

Hi @DavidSSAA,

 

According to your description above, you can just use the formula below to create a new measure(no matter in what table) as austinsense suggested above in this case. Both Con and Leads columns should be recognized and it should work.

Con/Leads = DIVIDE ( SUM ( Table1[Con] ), SUM ( Table2[Leads] ) )

If you still have any issue with creating the measure, could you post all your table structures and the measures you have tried using? It is better to share a sample pbix file. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.Smiley Happy

 

Regards

Thanks 🙂

Sorry for the numb question

where in the power bi i make this calulation?

because when i press the new measure button i get a new column in my table

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.