cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

DAX help - countrows with filters

Hi All,

 

 

I am new to DAX and have an issue with a measure that I am creating:

 

I am trying to count the number of times "chat wait time" or "Advisor Satisfaction" appears in a column using a measure (one works, one returns “blank)

 

 

This measure returns a result:

 

*Survey Completed = CALCULATE(COUNTROWS(vwSurveyResultsSubBU),FILTER(vwSurveyResultsSubBU,vwSurveyResultsSubBU[Question]="chat wait time"))

 

 

This one returns "blank" 

 

*Survey Completed1 = CALCULATE(COUNTROWS(vwSurveyResultsSubBU),FILTER(vwSurveyResultsSubBU,vwSurveyResultsSubBU[Question]="Advisor Satisfaction"))

 

Could anyone give me some advice on how to fix this please?

 

Many thanks,

 

Sean

2 REPLIES 2
Highlighted
Super User II
Super User II

Re: DAX help - countrows with filters

@drwinny From syntax point of view I don't see anything. Can you please if this string "Advisor Satisfaction" is available in Question column. Check if there are some space at the start or end of the string.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Regular Visitor

Re: DAX help - countrows with filters

@vimal_parmar I went into edit queries, selected the column, right clicked, selected transform and then trim text. 

I still have the same issue, thanks for the suggestion

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors