Help calculating % of reps contacted accounts rolled up to the Market level

[cb757]

I need to calculate what % of reps contacted 100% of their accounts by market. In the scenarion below for example, 50% of the East market contacted 100% of their accounts. 100% of the reps in the South market contacted 100% of their accounts. 0% for the West.  

rep	market	account	contacted
mike	east	0001	yes
mike	east	0002	no
carol	east	0003	yes
carol	east	0004	yes
alice	west	0005	yes
alice	west	0006	no
leroy jenkins	south	0007	yes
leroy jenkins	south	0008	yes
leroy jenkins	south	0009	yes
josh	south	0010	yes
josh	south	0011	yes

[cb757]

Thanks for the solutions offered Amit's will workfor my needs 🙂

[v-nmadadi-msft]

Hi @cb757,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[Ashish_Mathur]

Hi,

How did you arrive at the 100% and 50%.  Give a proper explanation.

[amitchandak · Accepted solution]

@cb757 . You can create a measure like

divide(countrows(filter(Table, Table[contacted] ="yes")) , countrows(Table) )

and should be able analyze by various attributes