measure in visual filter wanting number not text

[bsheffer]

I have a measure that returns text from a table which is overloaded so each name field contains a different data element and the value field contains a string.  Some of these strings are numeric but are stored as strings due to the mixed use.  So my measure is:

_acritem_Equipment_description =

calculate(

     FIRSTNONBLANK('Fact ACRITEM'[VALUE], 'Fact ACRITEM'[VALUE]),

     filter(

          'Fact ACRITEM',

          CONTAINSSTRING('Fact ACRITEM'[NAME], "Equipment") && CONTAINSSTRING('Fact ACRITEM'[NAME], "description")

     )

)

the table visual I put it in has the list of text values I expected.  But when I go to the filter pane and try to filter on these values, it just gives me numeric options or not blank.  Why isn't it giving the normal options of IS, CONTAINS, etc.?

[Pragati11 · Accepted solution]

Hi @bsheffer ,

Can you share the screesnshot for what is the data-type for this MODEL TYPE column?

I tried something similar at my end and it works fine:

 Can you try removing other filters and see if it works? I have a feeling that the already applied filters are doing something there.

Thanks,

Pragati

[Pragati11 · Accepted solution]

Hi @bsheffer ,

Can you share the screesnshot for what is the data-type for this MODEL TYPE column?

I tried something similar at my end and it works fine:

 Can you try removing other filters and see if it works? I have a feeling that the already applied filters are doing something there.

Thanks,

Pragati

[bsheffer · Accepted solution]

I didn't notice that measures default to decimal data type.  Once I changed the measure to text it worked fine.  Thanks for pointing me at the right place.

[Pragati11]

Hi @bsheffer ,

Can you please add some screesnhots on your issue specially the numeric options thing?

This is not making your issue clear.

Thanks,

Pragati

[bsheffer]

so you can see that the Model Type has text values but in the filter pane it is giving me an error when I type in a string.  If I type in a number it doesn't give an error but also doesn't give the desired result.  Also notice the autoformating of the field is right justified as if the column value was a number.

[bsheffer]

in case it wasn't clear:  Equipment Description = Model Type