If you add the index column that should not be the case because each line will have its unique index and upon doubling checking my DAX is still running for the reports I had created this for, that is strange though.
Try this calculated column. See file attached
Highest Order =
VAR HO =
CALCULATE ( MAX ( 'Order'[Amount] ) )
IF ( ISBLANK ( HO ), 0, HO )
View solution in original post
Join us in the third Triple A event!
It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.
Make sure you didn't miss any of the things that happened in the community in January!