SUMIF in ROW

[Anonymous]

 I wanted to add a row to my column with a sumif of two categories, so in the graphic of power bi the row will appear with the other categories (I don't want to see them separate).

 I don't know if this is possible. 😫

[Anonymous]

Hi  @Anonymous ,

Here are the steps you can follow：

1. Create calculated table.

Table_True =
var _table1=
SELECTCOLUMNS('Table',"CATEGORY","AB")
var _table2=
ADDCOLUMNS(
    _table1,"VALUE",
    SUMX(
        FILTER(ALL('Table'),'Table'[CATEGORY] in {"A","B"}),[VALUE]))
return
UNION(
    'Table',DISTINCT(_table2))

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[amitchandak]

@Anonymous , You can replace grand total with this total, Create a measure and use

if(isinscope(Table[Category]), Sum(Table[Value]) ,calculate( Sum(Table[Value]) , Table[Category] in {"A", "B"}) )

or you have to follow the approch

Power BI Formatted P&L with Custom Sub Totals and Blank Rows: https://medium.com/@amitchandak/power-bi-formatted-p-l-with-custom-sub-totals-and-blank-rows-e39ca822908a

You you only a new dimension with additional rows can do, extended dim you might not need