Statistic data at the end of matrix

Vote for summary tables here:
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13242426-add-summary-to-table-matrix

Sorry for late response :)

For summary with if function i had to create a new table with coppied dimensions in first column, (lets call it simple "Table").

I that column i coppied dimensions from original table in first columne "Category" (for example dimensions 1 to 5)  and added two additional dimensions (Dimension 6: Sum; Dimension 7: Average ).

In the second column ("Values") I writed values:

• 0 for dimensions 1 to 5
• 1 for dimension Sum
• 2 for dimension Average.

Then I connected new table to table with original dimensions.

Then I created formula 3 formulas,

• one for calculation i wanted in Matrix. Name of formula = [Calculation]
• one for Sum. Name of formula = [Sum]
• one for Average. Name of formula = [Average]

The last formula was with IF:

Ifformula:=if(
max(Table[Values])=1;[Sum];if(
max(Table[Values])=2;[Average];
[Calculation]))

In Power BI then I created matrix visualisation with categories from created table (With name "Table" :)) and with IF formula.

I am not sure if this formula is perfectly correct, but i hope you get the idea. This way of using IF also works for calculating values between rows. However, it has many problems:

• It is to complicate, it takes too much time
• It works pretty good in Power Pivot, but in Power BI, does not work always (maybe bugs?)
  • For example, in Power BI it works only if i don't sort data in tables.

Greetings,

Matej