Forum Discussion
Sumx, Relatedtable with Filter
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
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-8e3eccb41bda
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
Hi,
Share the download link of the PBI file.