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 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"
)
)
Anonymous's avatar
Anonymous
Not applicable
7 years ago

using your DAX but this time nothing is shown into the column

  • parry2k's avatar
    parry2k
    Super User
    7 years ago

    Anonymous i would recommend to share pbix wiht sample data to look into it. information you provided is hard to work with until someone else can assist you wiht this.

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    7 years ago

    Hi Anonymous ,

    Have you solved your problem?

    If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

    If you still need help, please feel free to ask.

    Best  Regards,

    Cherry