Forum Discussion
DAX Row Filter on Status
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]))
Or just pull [value.Status] as a visual filter and select "New" 🙂
4 Replies
Maybe this would work:
CALCULATE(
COUNT( 'All Applicants'[value.Region] ),
'All Applicants'[value.Region] = "New")
Gabriel_Walkman thanks for the feedback!
I just tried that, though no go, it didn't like me including that.
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.
Or just pull [value.Status] as a visual filter and select "New" 🙂
