Forum Discussion

texasmcse's avatar
texasmcse
Frequent Visitor
3 years ago

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...
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

texasmcse Maybe:

Measure = 
  COUNTROWS(
SUMMARIZECOLUMNS(
    'From MECM DB'[Operating System],
    KEEPFILTERS( FILTER( ALL( 'From MECM DB'[Operating System] ), SEARCH( "11", 'From MECM DB'[Operating System], 1, 0 ) >= 1 ))
)
)
texasmcse's avatar
texasmcse
Frequent Visitor
3 years ago

Greg_Deckler   If SUMMARIZECOLUMNS only returns distinct values, what function would return all values and work in my scenario?  Basically the equivalent of removing DISTINCT from a TSQL query.