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.
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 / support@eazybi.com