Cant match string

[Analitika]

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)

wtf?

rus_kod have no difference in codes "PARD" code in unique

[harshnathani]

Hi @Analitika ,

For Measure

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

For Column

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

Regards,

Harsh Nathani

Appreciate with a Kudos!! (Click the Thumbs Up Button)

Did I answer your question? Mark my post as a solution!

[Analitika]

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 😡

[harshnathani]

Hi @Analitika ,

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

Regards,

Harsh Nathani

[harshnathani]

HI @Analitika ,

if (CONTAINS('Table', Table'[rus_kod], "PARD"),1,0)

Regards,

HN

[Analitika]

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 😵

[harshnathani]

Hi @Analitika ,

Share the sample where it is returning 0.

Also share your .pbix if possible.

Regards,

Harsh Nathani

[Analitika]

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?

[Anonymous]

Hi @Analitika ,

Whether the date field used in slicer is from the same table with the field did_dat? If no, is there any relationship be created between two tables? In addition, could you please provide some sample data (exclude sensitive data) in order to make troubleshooting? It is better if you can provide your sample pbix file. Thank you.

Best Regards

Rena

[Analitika]

example here https://community.powerbi.com/t5/Desktop/Chart-to-count-stocks/m-p/1227965

[Anonymous · Accepted solution]

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]

result the same

[harshnathani]

Hi @Analitika ,

What is the expected output ?

Regards,

Harsh Nathani

Appreciate with a Kudos!! (Click the Thumbs Up Button)

Did I answer your question? Mark my post as a solution!

[Analitika]

All must be 1 as "PARD" always must be = "PARD"