KPI value not changing having set analysis in it

[prashantsanchet]

Hi Team,

I want to count the strategy but ignoring the strategy if values in variable vSales is zero.

I have written following expression in KPI Object:

count(distinct([Strategy.])) - count({<[Strategy.StrategyDescription] ={"=$(vSales)=0"} >} distinct [StrategyDescription])

i have one bar chart where i have strategy as dimention and vSales as measure and we are hiding zero values.

i have one filter as "vSelection" having different value as Q1,Q2,Q3;

Based on this selection i am calculating vsales variable value i.e if ( $(vSelection)='Q1, 'X'if ( $(vSelection)='Q2, 'Y','Z'))

But when i am comparing strategy count in KPI and chart are not matching if we change "vSelection" filter.

could you please suggest solution asap

[sunny_talwar]

May be you need this

Sum(Aggr(Count(DISTINCT [Strategy.]) - Count({<[Strategy.StrategyDescription] = {"=$(vSales)=0"} >} DISTINCT [StrategyDescription]), strategy))