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 kn...
Need Help
Tips and Tricks
Tutorial Requests
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