Forum Discussion
DAX expression with filtered text
My goal is to create a card visual that shows the number of rows in a database that have a specific word in a field. Example below from an MECM database looking for value '11'. That works, I j...
Can anyone help me figure out how to make the query not do a distinct count? I need the query to return all the rows that match the search so I can use it as a measure for a card visual. I've spent alot of time and just don't have the DAX skills yet to figure it out. thanks!
EVALUATE
SUMMARIZECOLUMNS(
MECM[OS],
KEEPFILTERS( FILTER( ALL( MECM[OS] ), SEARCH( "11", MECM[OS], 1, 0 ) >= 1 ))
)
still trying to figure this out. does anyone have any guidance? thanks