I have a question about calculating the measure. I will describe the case:
We have [ID ЗСЛ] (completed cases) that can have many [ID СЛ] (cases).
When we display [ID ЗСЛ] , [ID СЛ] and the SUM for [ID ЗСЛ] in the table, then the sum we have is calculated only for one [ID СЛ], for the rest 0 are displayed (Figure 1), but we need the sum of 918.22 to be displayed for all [ID СЛ] and in total it remains same. The indicator is calculated according to the formula
Sum(aggr(only([ЗСЛ-Сумма),[ID ЗСЛ]))
Could you tell me how to make the Sum of the [ID ЗСЛ] is calculated correctly and displayed for all child elements [ID СЛ], and not just for one wit save correct total?