Forum Discussion
Filter items which are not max id
hi, to get sum of distribution divided by countrows groupped by region_id of latest visit I have a calculation like this: var _sum =
SUMX(VALUES( fact_table[region_id] ), LASTNONBLANKVALU...
lokosrio This is sort of like a complex selector based on a lookup min/max measure like:
Distribution Max Period Measure =
VAR __Table = ALLSELECTED('Table')
VAR __Max = MAXX(__Table,[period])
VAR __Current = MAX('Table'[period])
RETURN
IF(__Current = __Max,[distribution],BLANK())