Forum Discussion
Totals Are For Only For One Column
Here is one of many possible implementations. Another option would be to combine your source tables.
Hi lbendlin,
The sample data is as follows:
- Target Table
| Department | Month | F.Y | Target | Type |
| A | Jan | 2022-2023 | 1000 | Target |
| B | Feb | 2022-2023 | 1050 | Target |
| C | Mar | 2022-2023 | 1100 | Target |
| A | Apr | 2022-2023 | 1000 | Target |
| B | May | 2022-2023 | 1050 | Target |
| C | Jun | 2022-2023 | 1100 | Target |
- Revenue table
| Department | Month | F.Y | Revenue | Type |
| A | Jan | 2022-2023 | 900 | Actual |
| B | Feb | 2022-2023 | 950 | Actual |
| C | Mar | 2022-2023 | 1000 | Actual |
| A | Apr | 2022-2023 | 900 | Actual |
| B | May | 2022-2023 | 950 | Actual |
| C | Jun | 2022-2023 | 1000 | Actual |
- Projections table
| Department | Month | F.Y | Projection | Type |
| A | Jan | 2022-2023 | 975 | Projection |
| B | Feb | 2022-2023 | 1025 | Projection |
| C | Mar | 2022-2023 | 1075 | Projection |
| A | Apr | 2022-2023 | 975 | Projection |
| B | May | 2022-2023 | 1025 | Projection |
| C | Jun | 2022-2023 | 1075 | Projection |
I have used a simple DAX for each i.e., Projection/Revenue/Target = SUM('table' [<projection/target/revenue>])
In order to get a matrix, I had created a calculation group of each i.e. Revenue, Target and Projection. However, after pulling the calculation group in the matrix, I am not getting column subtotals in Power BI Visualization.
Required output is column subtotals after each quarter for each Revenue, Target and Projections as below:
Kindly please provide some solution to get the above outcome.
Regards,
Saumitra
Here is one of many possible implementations. Another option would be to combine your source tables.