I have a DAX formula that seems to not be working. When it falls in the second “if” (see picture). There are Travel Distances that are 0 because it puts them into UNKNOWN when I believe it should fall into the CALCULATE section. Does that make sense?
Travel Distance Range = IF (RELATED('State Geography'[State Name])="International","International", IF ('Registration Info'[Travel Distance] = BLANK(), "Unknown", CALCULATE(VALUES('Travel Bins'[Name]),Filter('Travel Bins', 'Registration Info'[Travel Distance]>= 'Travel Bins'[Min] && 'Registration Info'[Travel Distance] <= 'Travel Bins'[Max]) )))