EazyBi : Aggregate function returns a wrong total

[Pierre Boucherie]

Hi everybody,

I am experiencing unexpected behavior with the following code in calculated measures:

Aggregate(

  Filter(

    Descendants([Issue].CurrentMember, [Issue].[Issue]),

    IsEmpty([Measures].[Issue Date intégration])

  ),

  [Measures].[Issue Nb de Folio]

)

The code returns the total for all issues on every row instead of computing by row member. However, when I use "drill through issues" on a single row, it correctly filters the issues by row members.

(On the "drill through" screen shot, it shows the correct list of issues and correct row count but the "Total value" should be 61 instead of 3627)

[Tomislav Tobijas]

Hi @Pierre Boucherie ,

I haven't been playing with eazyBI app, but I just want to say - if no help is provided here, you can always reach out to vendors directly via their support channels stated in the Marketplace listing.

Vendors are usually very helpful when it comes to troubleshooting or use case-related questions.

Cheers,
Tobi