DAX query

[Anonymous]

I have a table A

office id	user id	activation status
1	a	completed
1	c	completed
2	a	in progress
2	b	completed
2	d	new
2	c	completed

i want to create a chart like the below

For the above data,

result should be like 

Completed	4
inprogress	1
new	1

[v-yanjiang-msft · Accepted solution]

Hi @Anonymous ,

Has your problem been solved? If yes, please consider accept it as the solution to help the other members find it more quickly.

Best Regards,
Community Support Team _ kalyj

[Anonymous]

No,  it hasn't been resolved

[v-yanjiang-msft]

Hi @Anonymous ,

I attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[SpartaBI]

@Anonymous 

Create a Measure  = COUNTROWS('Table').
In the pie visual: Put the measure in the values and the 'id activation status' column in the legend