Forum Discussion

arielcedola's avatar
arielcedola
Icon for Helper III rankHelper III
6 years ago
Solved

Measure that needs the maximum value in a column, but disabling all interactions with the report

Hi, I need to create a measure that must use the maximum value in a column to perform a calculation. This maximum value, however, must keep unchanged even when in the page of the report there are sev...
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    ALL remove all filter context.

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

ALL remove all filter context.

  • arielcedola's avatar
    arielcedola
    Icon for Helper III rankHelper III
    6 years ago

    I already tried, but it didn't work:

     

    Measure = CALCULATE(MAX('Table'[Column]); ALL('Table'[Column]))

     

    But I realize now that I was using ALL in a wrong way: introducing the full Table as its argument works well.

     

    Thanks.