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 rows that [is in Range] column is zero.

 

These are my formulas

 

RankByDur = IF(ISBLANK([Total]), BLANK()
		,RANKX(ALLSELECTED(Hoja1[Duration]), [Total], ,0)
)
Is In Range = IF(ISBLANK([Total]), BLANK(),
               IF([RankByDur]>[Outlier Count] , 1, 0))
Total changing outlier = IF([Is In Range]=1
								,[Total] 
								, 1
)

Also if you want u can download pbix test from here:

https://www.dropbox.com/s/puq0nw8vrdg45zc/Replacing%20value%20test.pbix?dl=0

 

Thanks in advance,

  • Hi,

     

    Try this formula

     

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

    Hope this helps.

     

1 Reply

  • Hi,

     

    Try this formula

     

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

    Hope this helps.