Measure for removing data

In the above report, I want to remove the red-colored row. which has an Issue Resolved count = 3.
By doing so the total will come down by 23. I can do it by clicking the remove function.
But I am looking for a calculated measure, which will be applying whenever the report loaded.

Hi @sundararao.damaraju,

You could remove all rows that are 3 by clicking on the Done and selecting ≠ 3.

Another way to exclude one particular member is to write a calculation in the dimension by using Except(…) and Aggregate(…) functions.

Or lastly, instead of Except(…), you can write a more complex Filter(…) function.

Lauma /