I’m using the topn advice from the EDNA video to build a card showing a top performing group and bottom group. My top is fine, but my bottom (just changing is to asc) is bringing in blanks. For reference, I pulled a table in with the information thinking I would see blank fields, but I don’t see any from a filter standpoint. Any help would be greatly appreciated.
Bottom Ranked Area = CALCULATE(SELECTEDVALUE(DEPARTMENT[DESCRIPTION]),TOPN(1,ALL(DEPARTMENT[DESCRIPTION]), [Average Utilization],ASC))