Forum Discussion
Remove row value from total calculation
Hi Team, I have a table in Power BI visual with the rows and totals. Now while calculating totals, I need to remove one row value but include the others. For now the total in excel is sum of ...
DataNinja777
Super User
Super UserHi Anonymous ,
The robustness and reliability of Power BI and Power Pivot, compared to Excel, lie in their ability to perform calculations on entire columns rather than individual cells. As a result, it’s not possible to manually exclude specific rows without applying some logical criteria. My recommendation in this case is to introduce a field in your data table to flag the rows that should be excluded from the total. You can then use the 'calculate' function to exclude those flagged rows from the total calculation.
Best regards,