Forum Discussion
Optimizing the allexcept function
Hi, I have some data (Record ID and Key) and two measures (Selected and Max), which currently looks something like this: Record ID Key Selected Max 1 uniquekey1 0,67 1 uniq...
Perhaps:
Max =
VAR __Max = calculate([Selected]; ALLEXCEPT(Table, Table[Record ID]))
RETURN IF(ISBLANK([Selected]),BLANK(),__Max)
Max =
VAR __Max = calculate([Selected]; ALLEXCEPT(Table, Table[Record ID]))
RETURN IF(ISBLANK([Selected]),BLANK(),__Max)