Forum Discussion
Conditional values in Sub total
I am relatively amatuer in PBI. Can you help me out in this complex issue?
I have a table like this below in PBI
| Row Labels | Month | Campaign | Type | Revenue |
| 2019 | ||||
| 01 | ||||
| ABC | ||||
| Actual | $100 | |||
| Projected | $200 | |||
| ABC Total | $300 | |||
| DEF | ||||
| Actual | $300 | |||
| Projected | $400 | |||
| DEF Total | $700 | |||
| 01 Total | $1,000 | |||
| 2019 Total | $1,000 | |||
| Grand Total | $1,000 |
This is a standard pivot format. But what I want is that before the Month total, there should be 2 more subtotals - 01 Actuals Total and 01 Projected total. But these total should be outside of the campaigns. Something like below
| Row Labels | Month | Campaign | Type | Revenue |
| 2019 | ||||
| 01 | ||||
| ABC | ||||
| Actual | $100 | |||
| Projected | $200 | |||
| ABC Total | $300 | |||
| DEF | ||||
| Actual | $300 | |||
| Projected | $400 | |||
| DEF Total | $700 | |||
| 01 Actuals Total | $400 | |||
| 01 Projected Totals | $600 | |||
| 01 Total | $1,000 | |||
| 2019 Total | $1,000 | |||
| Grand Total | $1,000 |
Can you help me in achieving this? Thanks in advance
- Shalini
2 Replies
Anonymous , That is only possible when Actual and Projected are measures and show on Row is used.
Hi Anonymous,
There can only be one total in a layer, and you can put the Type into the columns of the matrix table to achieve the total method.
Or You can put your ideas on power bi ideas.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
