Calculated column or measure to review the highest result and return true or false

[Matt22365]

Hi All

Hoping someone can help

I have simplified my data below for the example

I need a calculation which will review all the tasks within a project (project number identifies which project is which) and returns whether any tasks in that project have a characteristic higher than 0. if it does I want it to return True, and False if only has 0

This is probably quite simple but I just cant get my head around it

Thanks in advance

Matt

Project Number	Task Number	Charateristic
1	1	0
1	2	1
1	3	2
2	1	0
3	1	2
3	2	3
4	1	2
4	2	0

[amitchandak]

@Matt22365 , a new column

new column =
var _cnt = countx(filter(Table, [Project Number] = earlier([Project Number]) && [Charateristic] =0 ), [Charateristic])
return
if(isblank(_cnt), false(), true())

a new measure

new measure =
var _cnt = countx(filter(allselected(Table), [Project Number] = max([Project Number]) && [Charateristic] =0 ), [Charateristic])
return
if(isblank(_cnt), false(), true())

[Matt22365 · Accepted solution]

Hi @amitchandak 

Thank you for your swift response, unfortuately I couldnt get your formula to work, however it did point me in the direction I needed to figure out a slightly different route which I do appreciate

My fix:

Calculated column to determine the Max characteristic value for each project (which I needed anyway)

Max Characterstic value =

VAR SID = 'Table'[ProjectNumber]

Return

Maxx(FILTER('Table','Table'[ProjectNumber]= SID),'Table'[Characteristic])

Then I did a 2nd column to determine whether IF Max Characteristic was "0" or blank to get my true and false statements

Thanks

Matt