I am relatively new, therefor a more basic question. But i just can't figure the solution.
I would like to calculated a table including a sum of one of the columns. The calculated row is summing up the values based on a certain characteristica. (I don't want to create a matrix visual)
The table are invoices with references to orders. I need to know the sum of order value
Desired Output Table
Please help. Much appreciated.
Go to Solution.
@beatbrun use a table visual,
add order number and Invoice Value and it will give you the sum of invoice value assuming it is a number field.
Proud to be a Super User! Appreciate your Kudos 🙂 Feel free to email me with any of your BI needs.
View solution in original post
myTableToo = SUMMARIZECOLUMNS('Table'[Order Number],"Sum Invoice Number",SUMX('Table','Table'[Invoice Value]))
Go to the Modeling tab, select New Table and add code.Let me know if you have any questions.If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.Nathaniel
Proud to be a Super User!
PERFECT! This is it! You made my day! 😄 @Nathaniel_C
Hi @beatbrun ,Glad I could help!Nathaniel
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.