Summerize data from 3 different tables

[dennisdepoorter]

Hi all,

I'm new to powerBI and DAX... and need some help with taking the sum of data from different columns from different tables.

Below you can see a picture what I want (calculated the first 2 lines... sorry for my drawing skills).

So the data is grouped on Name and calculates the amount of products that are ordered during a period (filter). We also have the quantity of products available at our distribution centre (BME.Quantity) and a Safety Stock (SS.Quantity). Now i want to summerize the 3 columns. By example the first line (ACN Cream) should be 5568, second line 2266, ...). Below you can also find our DTB Structure (Salesforce combined with some self made tables and our distributres warehouse export). Please help me out 🙂

THANKS!!!

Dennis

[Ashish_Mathur]

Hi,

If the last 3 columns are measures the, write this measure

=[Quantity]+[BME.Quantity]+[SS.Quantity]

[dennisdepoorter]

@Ashish_MathurDon't work (he mentioning "can't find the columns"... this is because it's in 3 different tables I think?

@v-danhe-msftSorry, can't do... is connected with Salesforce and all our data.... if you need some specifiek information about table relations,... don't hesitate to ask! 🙂

[dennisdepoorter]

@Ashish_Mathur, @v-danhe-msft

I made a copy of the DTB with fictional data:

https://www.dropbox.com/s/vupkg4chx07v5hf/test.pbix?dl=0

Hope this helps to figure out the problem

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[dennisdepoorter]

Hi @Ashish_Mathur,

The problem was in the fact I used columns instead of measures... it works now!!!

THANKS!!!!

[Ashish_Mathur]

You are welcome.

[v-danhe-msft]

Hi @dennisdepoorter,

Could you please share some sample file or the pbix file to have a test if possible?

Regards,

Daniel He