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"
        )