Forum Discussion
Solved
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, ...
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.
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 !