Forum Discussion
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...
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