Value mismatch after individual selection of item in bar chart

[#1]

Issue:  In bar chart,if i select particular dimension it shows 4 values.

Say,

SLC - 1.58

PNC - 2.14

IPQ  - 1.4

NM  -1.65

Issue Occurs when i select them individually. Values get floated upwards. e.g

• SLC - 1.58  -  1.69 (individual selection )
• PNC - 2.14  -  2.19 (individual selection )
• IPQ  - 1.4    -1.4  (individual selection )
• NM  -1.65    - 1.65 (individual selection )

This values vary after load.

Note: I am using 1 dimension (ProdName) and only 1 expression (1 expression for reference line, as per my knowledge it wont affect in this scenario)

Expression:

=sum({$<State_Cycle={'Approved'}>}AGGR(MAX({$<State_Cycle={'Approved'}>}Proof_Number), Proof_Number)) 

/count({$<State_Cycle={'Approved'}>} distinct Proof_Number)

Workaround

i have done workaround like checking expression in text box with hard coded value in above expression (e.g. ProdName={'SLC'}). Returns values after individual selection. (1.69)

Kindly help.

Regards,

Yudi

[#2]

Can you please explain what your expression doing ?

[#3]

Hey,

I got business logic for this KPI and i found the issue. Issue is at aggregated level.

Thanks.

Yudi