KPI default selection

[JoseGarcia]

Hi all, 

I am not a hundred percent if I am doing the following correctly:

I am trying to set a measure expression to show that if no selection is made, default value selection is set to High Risk, if other selection is made, the the KPI updates to selected risk.

Can anyone assist?

Thank you !

[lironbaram]

hi 

it should be something like 

if(getselectedcount(RISK_FIELD)=0, sum(IF(RISK_FIELD='high risk',Value)),sum(Value))

[JoseGarcia]

Thank you very much for your reply.

Here is my measure expression, but it is giving me a syntax error. where am I going wrong?

if(getselectedcount(ListItemsFromID_Riskdescription)=0, sum(IF(ListItemsFromID_FullImpact='High',Value)),sum(Value))

Details:

Chart type: Treemap

Dimension: ListItemsFromID_Riskdescription

Measure: if(getselectedcount(ListItemsFromID_Riskdescription)=0, sum(IF(ListItemsFromID_FullImpact='High',Value)),sum(Value))

[lironbaram]

hi 

i just checked on similar expression syntax and it's working , 

so it's something specific to your syntax , i don't see anything wrong 

can you post sample data 

[JoseGarcia]

here is a snapshot of the data, and an extract of the data file