DAX Row Filter on Status

[LyonsBI_BRL]

Recently I was able to create a map, being able to show data label values for each region

by using the instructions from the following YouTube video - https://www.youtube.com/watch?v=4ZOanVP1PS0

However I would like to be able to filter the number of rows I'm returning. Right now it's counting all rows per region. However I want to be able to filter within my DAX calcuation to filter on just the rows where value.Status = "New". I've taken a shot below to see about getting this to work though I'm getting hung up here within the formula. Any assitance here would be greatly appreciated. 

Count by State by Status = 
'All Applicants1'[value.Region] & " " &
'All Applicants1'[value.Status] & ":  " & 
CALCULATE(FILTER('All Applicants', 'All Applicants'[value.Status] = "New"),
COUNTA('All Applicants'[value.Region]),
ALLEXCEPT('All Applicants', 'All Applicants'[value.Region]))

[v-janeyg-msft]

Hi, @LyonsBI_BRL 

According to your description, If i understand what you mean, I think you can create a measure,then put it in filter pane to filter the data in visual. 

Like this:

measure = 
IF ( SELECTEDVALUE('All Applicants'[value.Status]) = "New", 1, 0 )

If it doesn't solve the problem, Please feel free to ask me.

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Gabriel_Walkman · Accepted solution]

Or just pull [value.Status] as a visual filter and select "New" 🙂

[Gabriel_Walkman]

Maybe this would work:

CALCULATE(

    COUNT(  'All Applicants'[value.Region] ),
    'All Applicants'[value.Region] = "New"

)

[LyonsBI_BRL]

@Gabriel_Walkman thanks for the feedback!

I just tried that, though no go, it didn't like me including that.