Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

filter and search

'TableName'[ColumnA] is of datatype Text with values such as 1422.02.02 200500 50100 6401.03.03 ... The below DAX does not show any values eventhough I see texts starting with the below values ...
Need Help
parry2k's avatar
parry2k
Super User
7 years ago

Anonymous what is measureb , then 2nd dax expression will fail if left of a string is blank and first one should work

Anonymous's avatar
Anonymous
Not applicable
7 years ago

measureB is number

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      I seem to be getting closer to my solution, however, the measureC column shows all values the same which is the sum of the MeasureB with ColumnA starting with 1 or 5

      Question, all data is from one table

      Not sure why all rows in MeasureC are repeated with the sum of MeasureB

      This is my DAX

      CALCULATE(
      [MeasureB]
      , not ISBLANK('TableName'[ColumnA]) && SEARCH(".", 'TableName'[ColumnA],,0) = 0
      && LEFT('TableName'[ColumnA], 1) = "1"
      ||LEFT('TableName'[ColumnA], 1)= "5"
      || LEFT('TableName'[ColumnA], 1)= "6"
      || LEFT('TableName'[ColumnA], 1) = "7"
      || LEFT('TableName'[ColumnA], 1) = "8"
      || LEFT('TableName'[ColumnA], 1) = "9"
      )

      • parry2k's avatar
        parry2k
        Super User
        7 years ago

        Anonymous not going into your measure, add following 

         

        CALCULATE(
[MeasureB]
, 
KEEPFILTERS(
not ISBLANK('TableName'[ColumnA]) && SEARCH(".", 'TableName'[ColumnA],,0) = 0
&& LEFT('TableName'[ColumnA], 1) = "1"
||LEFT('TableName'[ColumnA], 1)= "5"
|| LEFT('TableName'[ColumnA], 1)= "6"
|| LEFT('TableName'[ColumnA], 1) = "7"
|| LEFT('TableName'[ColumnA], 1) = "8"
|| LEFT('TableName'[ColumnA], 1) = "9"
)
)