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)