KPI chart with percentage

[Olya]

Hi all,

How can I make the KPI chart with two KPI's - the first one should be an absolute number and the second KPI should show this number in percentage.  I have used the expression: 

count([Opportunity Line Number])/count(total [Opportunity Line Number])  for the percentage formula

but it shows always 100%, even I do selections in the other charts.

Thanks

[sugathirajkumar]

can you provide the sample data

[StarinieriG]

It's correct that it is always 100 % because if you count a field (with selection or not) without set analysis for example, count total anyway.

Then those two expression are always the same.

[asinha1991 · Accepted solution]

total outside chart make no sense, maybe you want this?

count([Opportunity Line Number])/count({1}[Opportunity Line Number])

[Olya]

thanks! What is what I needed  🙂