How to display Management accounts in conventional format

[masplin]

Was reading this post about how to get acconting data to dispaly correctly in powerpivot drill-income-statement-design but can't get it working in Power BI as doesn't show any of the entries fror EBITDA etc only the ones that are the sum of some defined rows e.g. 

Total Marketing = CALCULATE([Total Actual],Budget_L1[Budget L1]="Marketing")

whereas EBITDA is defined as

EBITDA = [Total GP test]+[Total Staff Costs]+[Total Marketing]+[Total Overheads]

where each component has same form as the Marketing one

So is there some limitation in PBI that the SWITCH function doesn't work the same?  

Is there some other way to show a matrix that includes both regualr pivottable like sums and also calcuated measures?  The article seemed to be the answer , but can't work out why it doesn't work!!!

Thanks for any advice or alternative suggestions

Mike

[v-ljerr-msft · Accepted solution]

Hi @masplin,

I just tested it that all the measures mentioned in the article works fine with Power BI Desktop. Here is the test pbix file for your reference. 

Regards

[masplin]

Actually I think you have the same issue as i'm seeing. In the Header table the 3rd item is Gross profit and the switch uses [GP Act] as the measure.  However when you create the matrix it doesn't show up. I compacted your matrix to the top level and you see this

So despite defining the Header as below, headers 3,5 and 10 don't actually show up despite just being functionsof other eleemnts that do show up. seems realyl strange it can show Revenue and CoS but not Gross profit which is the combination of the 2. The only difference is the GP measure does not include any explicit refernce to the header table. 

[masplin]

Hmmm must be somethnig different i have in my table structure. Thanks for doing that as confirms i should persist

Mike