Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

EazyBi : Aggregate function returns a wrong total

Pierre Boucherie
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
April 25, 2025

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)
easyBI_drillthroughissues.pngCapture d'écran 2025-04-25 114316.png

0 answers

Suggest an answer

Log in or Sign up to answer