Ignoring Filter in AGGR Set Expression

[alliedarmour]

Hello!

I wanr ro build a KPI for an average value of patients in the selected year - means I want to include the selected year as filter but want to use all 12 months and all quarters:

Avg(Aggr(Count(
{$<Quarter =, Month=> * (<FallBewegungKey = {"=Aggr(Count(ICD), FallBewegungKey) > 0"}> +
<FallBewegungKey = {"=Aggr(Count(Leistungsziffer), FallBewegungKey) > 0"}>)}
DISTINCT Fallnummer), Month))

But still, if I select a month via a table, the selection is still applied and the KPI changes accordingly, while it should be ignored.

What am I doing wrong in this place?

[BrunPierre]

Try.

=Avg({<Quarter=,Month=>}Aggr(Count({<Quarter=,Month=>}{<FallBewegungKey={"=Aggr(Count ({<Quarter=,Month=>}ICD), FallBewegungKey) > 0"}> + <FallBewegungKey={"=Aggr(Count ({<Quarter=,Month=>}Leistungsziffer), FallBewegungKey) > 0"}>}DISTINCT Fallnummer), Month))

[alliedarmour]

Hey, thanks for your solution, but unfortunately it's still not working 😐

[alliedarmour]

But I figured out that the nested AGGR-functions are indeed the problem. If I delete them, it seems to be working. Any workaround for this?