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:
Thanks in advance!
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]))))
View solution in original post
COUNTROWS ( 'Table' )
/ CALCULATE ( COUNTROWS ( 'Table' ), REMOVEFILTERS ( 'Table'[Status] ) )
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.