Forum Discussion

DouweMeer's avatar
DouweMeer
Icon for Impactful Individual rankImpactful Individual
7 years ago
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...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    7 years ago

    Juse use a MAXX or MINX on that single row table, if I understand what you are saying.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
7 years ago

Juse use a MAXX or MINX on that single row table, if I understand what you are saying.

DouweMeer's avatar
DouweMeer
Icon for Impactful Individual rankImpactful Individual
7 years ago

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.

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    7 years ago

    I was wondering because it seemed like you had done that for VAR2. Perhaps you used a numerica aggregation before like SUMX?

    • DouweMeer's avatar
      DouweMeer
      Icon for Impactful Individual rankImpactful Individual
      7 years ago

      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.