Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

SUMIF in ROW

 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. 😫

Need Help
Tips and Tricks
Tutorial Requests

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    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

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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