Forum Discussion

Analitika's avatar
Analitika
Icon for Post Prodigy rankPost Prodigy
6 years ago
Solved

Cant match string

I have measure nor one of that is not work Measure = if("PARD" IN DISTINCT ('Table'[rus_kod]) ,1,0) Measure = if("PARD" = max('Table'[rus_kod]) ,1,0)     rus_kod have no difference in cod...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Analitika ,

    Thanks for sharing your pbix file. As checked the data which the value of field rus_kod is "PARD", there is only one record which did_dat is on Mar 3, 2015. And as put the following measure on the table visual, it works well. I'm not sure if something missing here and cause that can't reproduce your problem...

    Best Regards

    Rena

Analitika's avatar
Analitika
Icon for Post Prodigy rankPost Prodigy
6 years ago

As i mentioned 

For Measure

 Measure = if(MAX('Table'[rus_kod] )= "PARD" ,1,0)

 

is not work and return me for half 0 for other 1 ðŸ˜¡

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Analitika ,

 

Measure = if(TRIM(MAX('Table'[rus_kod] ))= "PARD" ,1,0)

 

Regards,

Harsh Nathani

  • Analitika's avatar
    Analitika
    Icon for Post Prodigy rankPost Prodigy
    6 years ago

    result the same

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    HI Analitika ,

     

    if (CONTAINS('Table', Table'[rus_kod], "PARD"),1,0)
     
    Regards,
    HN
    • Analitika's avatar
      Analitika
      Icon for Post Prodigy rankPost Prodigy
      6 years ago

      result the same, it like a bug also visual do not showing value from rows ðŸ™„

       

      if i recreate file measure working, but after couple of time stop works again ðŸ˜µ

      • Analitika's avatar
        Analitika
        Icon for Post Prodigy rankPost Prodigy
        6 years ago

        foun what this is happens if date selected, but dont understand why it showing values in table if not meet date?
        Why values is showing if not meet date?