My Exception Function is duplicating Issues

I created a calculated member to remove some Labels from a report.

I used the following formula:


The problem is when we have issues with more than one Label. We found cases with issues with 2 labels and in the report the item was duplicated.

I would like that in cases where there is more than one Label in the issue, the report displays the value 1.

Hello @Joao_Batista_de_Sous
Welcome to the eazyBI Community!
Thanks for posting your question!

Label is a multi-value field, and indeed, when multiple labels are used, you might see some “duplications”.

I recommend checking out this community post - Counting labels multiple time regarding the same scenario and a solution.

Best wishes,

Elita from

1 Like