Forum Discussion

jpereztang's avatar
jpereztang
Icon for Helper I rankHelper I
8 years ago
Solved

Change measure value based on measure

Hi everyone,   I know you have an idea how to achieve it.   this is my data   As simple as it appears i want to put the max value of Total column when [Is in Range] column is 1 for all ro...
Need Help
Tips and Tricks
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    Try this formula

     

    =if([Is In Range]=0,MAXX(FILTER(ALL(Hoja1[Duration]),[Is In Range]=1),[Total]),[Total])

    Hope this helps.

     

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

Try this formula

 

=if([Is In Range]=0,MAXX(FILTER(ALL(Hoja1[Duration]),[Is In Range]=1),[Total]),[Total])

Hope this helps.