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
gkalandadze
Frequent Visitor

Divide summed income on store area

Hey,

i'm new. need help

 

Got this situation : these are different tables, I need to divide sum of each branch income on a branch area.
example Poti 68/100
thanks in advance

 

Capture1.PNGCapture22.PNG

1 ACCEPTED SOLUTION

Dude you need to change the table names.

 

View solution in original post

6 REPLIES 6
Pulkit
Resolver I
Resolver I

Hi,

 

Create a new column on the table with Area using this DAX.

 
Column = CALCULATE(SUM(Table1[Sold]))/Table2[Area]

no it doesn't work. it can't include table2 (((

What's the error?
Is there any relationship between these two tables?

yes there are relationship between them. but shows an error

 

3434.PNG

Dude you need to change the table names.

 

thanks man!

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.