Forum Discussion
DAX Average based on text - AVG grouped by other column value
Hi!
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 | |
| Europe | 66% | 33% | |
| Asia | 100% | ||
| Africa | 50% | 50% | |
| Latin America | 100% | ||
| Total | 25% | 62,5% | 12,5% |
| Region | Status |
| Europe | Completed |
Europe | Delayed |
| Asia | Not Started |
| Europe | Completed |
| Africa | Not Started |
| Latin America | Completed |
| Latin America | Completed |
| Africa | Completed |
Thanks in advance!
S_N_L_A , Try a measure like
divide(counrows(Table), calculate(counrows(Table), filter(allselected(Table), Table[Region] = max(Table[Region]))))
2 Replies
- amitchandak
Super User
S_N_L_A , Try a measure like
divide(counrows(Table), calculate(counrows(Table), filter(allselected(Table), Table[Region] = max(Table[Region]))))