Forum Discussion
Sub total in a Table with several columns
Dear all,
I want to have subtotals in a table in PowerBI. Just the total amount for each contract as in the picture below. I tried with DAX formula with creation of new data table, or using matrix, but I don't manage to get this result which takes me 5 mn in Excel.
Could someone help?
Thank you.
In the picture, on top what I have, and below what I want:
Hi LolHlde , hello selimovd, thank you for your prompt reply!
Use the matrix visual instead of the table visual, check the following steps:
- Add Contract Number ,title ,supplier and country to the Rows section, and add "Amount" to the Values section:
- Change the Layout to Tabular:
- Navigate to the Row subtotals setting, enable the subtotal for the first and second-level "Contract Number" and "Title," and turn off subtotals for other levels:
Result for your reference:
Best regards,
Joyce
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
- selimovd
Most Valuable Professional
Hey LolHlde ,
yes, you can do that with subtotals in the rows.
Just turn them on in the settings of the visual.
If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
Best regards
Denis
Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic
Connect with me: LinkedIn I can't find it the the visual "Table":
Hi LolHlde , hello selimovd, thank you for your prompt reply!
Use the matrix visual instead of the table visual, check the following steps:
- Add Contract Number ,title ,supplier and country to the Rows section, and add "Amount" to the Values section:
- Change the Layout to Tabular:
- Navigate to the Row subtotals setting, enable the subtotal for the first and second-level "Contract Number" and "Title," and turn off subtotals for other levels:
Result for your reference:
Best regards,
Joyce
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you !
