How to modify if maxx is not applicable to *

[Anonymous]

I have the following DAX in order to see the last result have * or not. If last result have *, then current result should also have *, in order to make the * in last result can be in the same row of current result. However, what i am looking for is *, but not a value. So, MAXX seems not applicable. Do anyone know what i should modify?

transformation star = var _date1 = MAX('Q25_TOP5'[Survey Close Date])

var _name = FIRSTNONBLANK('Q25_TOP5'[Facility Name + ID],"")

var _date2 = MAXX(FILTER(filter('Q25_TOP5','Q25_TOP5'[Facility Name + ID]=_name),'Q25_TOP5'[Survey Close Date]<_date1),'Q25_TOP5'[Survey Close Date])

var _star = MAXX(FILTER(Q25_TOP5,Q25_TOP5[Survey Close Date]=_date2),Q25_TOP5[Star(last)])

RETURN IF(Q25_TOP5[Current/last]="Current Survey" && _star="*","*","")

[amitchandak]

@Anonymous , Based on what I got. You can get latest value using these blogs.

https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0

https://amitchandak.medium.com/power-bi-get-the-sum-of-the-last-latest-value-of-a-category-f1c839ee884e

and then you can check for * value

[Anonymous]

but It seems that the link is all about values, instead of non-value, like * in my case.