I'm certain that there is an answer to this that I've stumbled upon before. But after almost 2 days of searching (probably my searching skills that are lacking) I'll have to post a question.
I have a table where two of the columns are Region and Status.
What I'd like to do is to create a DAX which calculates the average count of "Status" per "Region" as well as total.
In other words the end result (that I want to have as a visualization) should be:
| ||Not started||Completed||Delayed|
|Asia||100%|| || |
|Latin America|| ||100%|| |
Thanks in advance!