My Exception Function is duplicating Issues

Questions & Answers
,
1

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

I used the following formula:

Aggregate(
Except(
[Label].[Label].Members,
{
[Label].[Prime_4X],
[Label].[Membership_4X],
[Label].[Ofertas_4X],
[Label].[Coupon_4X],
[Label].[Controlados_4X],
[Label].[HealthHub_4X],
[Label].[Univers_4x],
[Label].[Loyalty_4X],
[Label].[MyAccount_4X]
}
)
)

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.

eazyBi01
eazyBi01727Ă—166 5.5 KB

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

2

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

1 Like