Forum Discussion
Sumx, Relatedtable with Filter
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.
Cannot understand anything in that file at all. Do not know what the problem is and neither do i know what you want.
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
6 Replies
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-solution-8e3eccb41bdaHi 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
Hi,
Share the download link of the PBI file.
