Remove rows from data

Hi Anonymous ,

We can use two ways to meet your requirement. One is in Power Query Editor, another is to create a calculate table.

1. In Power Query Editor, we can create a conditional column. The “Total” is 0, others are 1.

2. Then we filter out the value of 0 in custom column.

3. At last we delete the custom column, the result like this,

Or we can create a calculate table using DAX.

Table 2 = SUMMARIZE(FILTER('Table (2)','Table (2)'[ColB]<>"Total"),'Table (2)'[ColA],'Table (2)'[ColB],'Table (2)'[ColC])

If them don’t meet your requirement, could you please show the exact expected result based on the table that you have shared?

BTW, pbix as attached.

Best regards,

Community Support Team _ zhenbw

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