Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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:
Solved! Go to 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
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.
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
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.
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
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.
in case it wasn't clear: Equipment Description = Model Type
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
60 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |