cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

Sum using mutiple table

@Nathaniel_C 
Hi so im trying to build a measure, the main table im using is the "LDet2" . I have this measure that ive created inside of LDet2 : 
getting it from another table which is called BR.

63.JPG

 

So, when i include that measure in the table it becomes like this:

61.JPG

and im not really sure on what to do next 😞

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: Sum using mutiple table

Hi @Ellensantiago1 ,

Are your tables similar to  mine?

‘BR’ table:
c15.PNG

‘LDet2’table:

c16.PNG

The relationship between them:

c19.PNG

Is what you want to get the sum of  ‘BR[Total lab]’ and ‘BR[Total P&O]’?

After you get the sum, do you want to map it to ‘LDet2’ table?

If yes, firstly, you can create a column in ‘BR’ table:

 

Column = BR[Total lab] + BR[Total P&O]

 

c18.PNG

 

Then, map this column to ‘LDet2’ table by using ‘LOOKUPVALUE()’ function:
LOOKUPVALUE(): https://docs.microsoft.com/en-us/dax/lookupvalue-function-dax

I can’t complete the step, because I need more columns of ‘BR’ table.

If I have a wrong understanding of your issue, you can describe your needs again (what you want to realize) and give me the data which need to use in calculation.

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

Best regards,
Lionel Chen

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Highlighted
Helper II
Helper II

Re: Sum using mutiple table

@v-lionel-msft 

 

Hi,

you can take a look at this data so you can understand it more and check it out. Because i really don't know on what can i do to it 😞 Tried so many solutions already. 

btw, I've created the column already under BR: (really need help 😞 )
65.JPG

https://drive.google.com/file/d/1AWIkw4Y4q0kpaeeJpFuNDpnQz9Z29aR8/view?usp=sharing

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors