measure expression and dimension in pie chart

[MarcoAmbrosio]

I want a percentage, that work also as a filter for this thing. Here this is an example of the table.

CodOffice	IdPractice
101	54645
101	123546
102	-
103	4568
104	7987

In my pie chart a want a percentage of how many CodOffice have at least one IdPractice and how many CodOffice don't have an IdPractice

[Diter]

Hi Marco,

Maybe this can help you.

1. you can add a category calculated with a formula: if([IdPractice]>0, 'at least one id Practice', 'dont have an Id Practice')

2. then you can count the CodOffice:  count(distinct CodOffice)

3. finally you can built the pie chart and use it as a filter

Please see attached images

Regards,