Forum Discussion
Solved
select value in table
So... for something different. I created the following in a custom column: VAR a1 = SELECTCOLUMNS( filter ( 'Case History' , and ( 'Case History'[CaseId] = 'Case...
Juse use a MAXX or MINX on that single row table, if I understand what you are saying.
When I tried it, it didn't work and BI suggested it was due to string value. Now this Super User comes along and suggests my earlier thought and it just does somehow work.... how....? (rhetorical)
Greg_Deckler Thanks Greg.
I was wondering because it seemed like you had done that for VAR2. Perhaps you used a numerica aggregation before like SUMX?
I think it is most likely that I made an error in my context which made it happen that one of the applied filters wasn't working, thus you would have multiple results. Something that might break it, I assume.