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!
Solved! Go to Solution.
@S_N_L_A , Try a measure like
divide(counrows(Table), calculate(counrows(Table), filter(allselected(Table), Table[Region] = max(Table[Region]))))
Hi @S_N_L_A
Try this:
Measure =
COUNTROWS ( 'Table' )
/ CALCULATE ( COUNTROWS ( 'Table' ), REMOVEFILTERS ( 'Table'[Status] ) )
the output:
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Hi @S_N_L_A
Try this:
Measure =
COUNTROWS ( 'Table' )
/ CALCULATE ( COUNTROWS ( 'Table' ), REMOVEFILTERS ( 'Table'[Status] ) )
the output:
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
@S_N_L_A , Try a measure like
divide(counrows(Table), calculate(counrows(Table), filter(allselected(Table), Table[Region] = max(Table[Region]))))
User | Count |
---|---|
74 | |
37 | |
33 | |
16 | |
13 |
User | Count |
---|---|
83 | |
30 | |
26 | |
16 | |
13 |