Sumx, Relatedtable with Filter

[AllanBerces]

Hi Good day,

Can anyone pls assist me on my table. I want the sum of Article per ID. im not sure if the relation of my table are correct.

Thank you.

[Ashish_Mathur · Accepted solution]

Cannot understand anything in that file at all.  Do not know what the problem is and neither do i know what you want.

[amitchandak]

@AllanBerces , I this case you also need a common dimension ID, that would be better, and then you can use material and ID from Dimensions

Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-soluti...

[AllanBerces]

Hi @amitchandak 

I have already the Bridge tabel 

But the data im getting is the sum of all per article. Maybe i need to used the relatedtable function and sumx, but i dont know how to construct it correctly.

Thank you

[Ashish_Mathur]

Hi,

Share the download link of the PBI file. 

[AllanBerces]

Hi @Ashish_Mathur 

https://www.dropbox.com/scl/fi/tqti55y3aj6wri6aps5do/test-02-2-1-1.pbix?rlkey=8fkfyhe0rsbsdwf6iyhld5...

[Ashish_Mathur · Accepted solution]

Cannot understand anything in that file at all.  Do not know what the problem is and neither do i know what you want.

[AllanBerces · Accepted solution]

Hi @Ashish_Mathur 

Basically i want to get the sum of Articel No. in Article Table per Project ID_Article.

Let say on the example below im getting the overall sum of 1000255095 on diffirent Project ID_Article Column from Ariticle table. 

Thank you