Chart with percentage

[RaquelFQSpain]

Hi,

I have a chart, with dimension: ValueList('Vida','Coche')

and measure:

If (ValueList('Vida','Coche')='Vida',(Count([ID])/Count(total [ID])), If (ValueList('Vida','Coche')='Coche',(Count([ID])/Count(total [ID]))))

I don´t get any error, but I didn´t get the correct results, and also I need in percentage.

ID	PROVINCIA	COCHE	MOTO	HOGAR	SALUD	DENTAL	VIDA	ACCIDENTES
2	Barcelona	Coche		Hogar
3	Zaragoza			Hogar
5	Madrid	Coche	Moto		Salud
15	Sevilla	Coche		Hogar	Salud			Accidentes
16	Madrid			Hogar		Dental
26	A Coruña	Coche		Hogar
39	Las Palmas	Coche
40	Madrid	Coche	Moto	Hogar	Salud
60	Barcelona			Hogar
62	Madrid	Coche
68	Madrid	Coche		Hogar			Vida
89	Madrid	Coche		Hogar			Vida
104	Madrid			Hogar
117	Valencia	Coche		Hogar		Dental		Accidentes

Thanks!

[joaopaulo_delco · Accepted solution]

Hi @RaquelFQSpain !

    I think you can try this formula

If (ValueList('Vida','Coche')='Vida',(Count({<VIDA-={"-"}>}[ID])/Count(total [ID])), 
If (ValueList('Vida','Coche')='Coche',(Count({<COCHE-={"-"}>}[ID])/Count(total [ID]))))

[RaquelFQSpain · Accepted solution]

Thank you so much!!!!!

[joaopaulo_delco]

Hi @RaquelFQSpain !

   I think you mark as solution the wrong post.