I want to create a report that excludes the status of Done and Cancelled - I created a filter below that shows the Done but I want to show all status except done and cancelled
Aggregate(
Filter(
[Status].[Status].Members,
[Status].CurrentMember.Name = “Done”
)
)
Hi Brian,
In this case you may want to use a slightly different approach when creating a calculated member:
Aggregate(
Except(
[Status].[Status].Members,
{ [Status].[Done],
[Status].[Cancelled]
}
)
)
Please find more information here:
https://docs.eazybi.com/display/EAZYBI/Calculated+members#CalculatedMembers-Aggregatemembersinotherdimensions
Best regards,
Martins / eazyBI team
1 Like