How to use a default value for a KPI calculation if nothing is selected

[dmitroika]

Hi Guys,

Please I urgently need assistance with the following problem:

I am looking for a solution to use for a KPI calculation if nothing is selected.

E.g: the KPI must display a selected country's sales data (e.g Poland) if no country is selected. However, if a country is selected then that country's data should then be displayed.

I tried the following expression but I receive an error message: Nested aggregation not allowed.

If(GetSelectedCount([Country]=0,

sum({<[Country]={'Poland'}>}[Sales]),

sum([Sales]))

Thank you!

[Stoyan_Terziev · Accepted solution]

Hi,

Small formula fix missing ')':

=IF(GetSelectedCount([Country])=0,
sum({<[Country]={'Poland'}>} [Sales]),
sum([Sales]))

Kind regards,

S.T. 

[dmitroika]

Thanks S.T. 

It worked!