Hi Good day,
Can pls someone help me how can i get the output i desire. I want the sum per article per project id.
Thank you
1 ACCEPTED SOLUTION
@AllanBerces Put Article No, Unit and Project ID_Article in a table visual. Add the sum of Quantity.
Or, if you want a calculated table:
Output Table = SUMMARIZE('Table', [Article No], [Unit], [Project ID_Article], "Unit", SUM('Table'[Unit]) )Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
@AllanBerces Put Article No, Unit and Project ID_Article in a table visual. Add the sum of Quantity.
Or, if you want a calculated table:
Output Table = SUMMARIZE('Table', [Article No], [Unit], [Project ID_Article], "Unit", SUM('Table'[Unit]) )Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
