Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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 |
---|---|
15 | |
11 | |
6 | |
6 | |
5 |
User | Count |
---|---|
29 | |
17 | |
11 | |
7 | |
5 |