Column that counts the number of values ​​for the same ID

[Anonymous]

I'm trying to create a column that counts the number of rows for each ID where the column "Proof" is blank. 

Each person has a unique ID and they can have different courses linked to them. The "Proof" column informs whether the person has proof of that course was completed or not. If it's blank, it means the person doesn't have proof yet.
I want to create a column that shows the number of rows where the "Proof" column is blank for the same ID.

My table follows this structure:

ID	Person Name	Course	Proof
1	Jack	Social Study	Yes
1	Jack	IT
2	Rose	IT	Yes
3	Sindra	Advanced Math	Yes
3	Sindra	Digital Pilot
3	Sindra	Team Management

The expected result with this new column would be this:

ID	Person Name	Course	Proof	Count
1	Jack	Social Study	Yes	1
1	Jack	IT		1
2	Rose	IT	Yes	0
3	Sindra	Advanced Math	Yes	2
3	Sindra	Digital Pilot		2
3	Sindra	Team Management		2

[Ashish_Mathur]

Hi,

Write this calculated column formula

Count = calculate(countrows(Data),filter(Data,Data[ID]=earlier(Data[ID])&&Data[proof]=blank()))

Hope this helps.

[vicky_]

Here's a measure that you could use:

Count = CALCULATE(COUNTROWS('Table (2)'), 'Table (2)'[Proof] = "", ALLEXCEPT('Table (2)', 'Table (2)'[ID  ])) + 0

Hope it helps.