Forum Discussion
DAX query
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 |
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
4 Replies
Anonymous
Create a Measure = COUNTROWS('Table').
In the pie visual: Put the measure in the values and the 'id activation status' column in the legendHi 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 _ kalyjHi Anonymous ,
I attach my sample below for reference.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
